Subtract a Measure over two periods in Pivot Table

[zahidrahim_ocp]

Dear Experts,

I have a pivot table where i add period code in column and stock value is my measure where i can see my stock value comparison over two periods. Now i want to add the difference of stock value in two periods to show the variance.

Current

Stock Category          DEC-17     JAN-18

A                                        100          110    

B                                        200          210

C                                        300          310

Desire

Stock Category          DEC-17     JAN-18     Variance

A                                        100          110          10

B                                        200          210          10

C                                        300          310          10

Regards,

Zahid Rahim

[MohammedMustaq]

If you doing this in Pivot table you can try this.

=Column(2)-Column(1)

Thanks

[agigliotti]

you should create two measures for the two comparison periods, in order to have a third measure (variance) as Column(2)-Column(1).

use Stock category as the only one dimension.

[sunny_talwar]

Is Period Code a dimension? Also, if the first statement is true, are you going to always look at just two months at a time? If not, then how will your variance column look like if you have 5 months in your chart?

[consultant_bi]

you have to add a measure by going to the Data Manager and then your new calculated measure from the two columns you want

[DeshDeepSingh]

But this is not adding the new column. I am using the same expression in Pivot table