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:
screen shot of measure for profit column:
CodePudding user response:
Try Changing the formula to
=SUM([Amount]) - SUM([Actual cost of units])