4 Replies Latest reply: Jan 29, 2018 9:59 AM by Fathi Ali RSS

    Subtract a Measure over two periods in Pivot Table

    zahid Rahim

      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