Adding or Subtracting categories

Dear Community, 

 

I have a column called CATEGORY. In this column I have 3 values 

1. Actual

2. FX_DIFF

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 

Attachments

AttachmentSize
Image icon category.jpg35.74 KB

(1) Answer

Login