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
LinkedIn
Twitter
