Adding or Subtracting categories
I have a column called CATEGORY. In this column I have 3 values
3 RFF 2019.07
I have created a pivot table that has CATEGORY in the columns, PROFIT CENTER in the Rows and the value dimension is called AMOUNT.
I would like to add in an additional column called difference at the end of the pivot table that does Actual - FX_DIFF - RFF 2019.07 = Difference