Home > other >  Incorrect Calculations in Pivot table when adding a measure
Incorrect Calculations in Pivot table when adding a measure

Time:06-21

I have made a pivot table of data in which there is a row label and two columns - sum of amount and sum of the actual cost of units, also I have added a measure (profit) which has the formula of subtraction between two sums column.

After adding the profit measure to the pivot table values, the calculated individual profit values are all incorrect and grand total is also incorrect.

How to fix the incorrect values?

screen shot of result from pivot table: enter image description here

screen shot of measure for profit column: enter image description here

CodePudding user response:

Try Changing the formula to

=SUM([Amount]) - SUM([Actual cost of units])
  • Related