10 Replies Latest reply: Jun 6, 2015 4:14 AM by Antonio Mancini RSS

    How to calculate the difference of sum in a PivotTable for specific values of one dimension

    KOSMAS PAPAKOSMAS

      Hi all,

       

      I have one Table with : Product, Day , Quantity

       

      The Pivot Table has as dimensions Product , Day with sum(Quantity) as Expression.

       

      How could I calculate the difference of the sum per product between e.g. Day 1 - Day7 , Day 6 - Day 4

       

      Product Day      1        2     ....       7

      A                    90     100     ----     75     To calculate 90-75 = 15 (The difference of the sum of Day 7 and Day 1 per product)

      B                    92                 ----     82      92-82=10

      C                    95                 ----     46      95-46=49

       

      Thanks a lot