Pivot Table Volume calculation error

Hello Community,

I am having one issue on the Pivot table calculation. This is to calculate process failure. it looks like this as shown below-

Original Data:

Service Provider -------- Process Issue------Logistics Volume

XXXXXXXXXXX --------- 8 -------------------------20000

But Calculated Data on Pivot Table:

Service Provider -------- Process Issue------ Logistics Volume

XXXXXXXXXXX --------- 8 -------------------------160,000???

The Logistics volumes should be 20000 not 160,000. the volumes are getting multiplied with the “Process Issues”, which is (8 x 20000 = 160,000).

In the backend no calculated fields are created, but on the pivot table its calculated wrong.If anyone knows any solution then kindly please share. Thank you all for supporting 🙂

With Regards,

Imran

0 1 183
1 REPLY 1

28892c92-492b-4cb2-a840-8f746aa5fbdc.png

I tried putting the Volumes aggregation to Average, then the grand total is wrong but the volumes are right. If i put the volumes aggregation to SUM then its getting multiplied with the NC Logistics Count. If anyone knows how to fix this then kindly please let me know 🙂 thanks for your time and help 🙂

Top Labels in this Space
Top Solution Authors