13 Replies Latest reply: Nov 25, 2013 3:43 PM by Shuyu Wang RSS

    Subtract from a fixed cell in pivot table

      Hi,

       

      I have Monthly Target number as one line and Actual Sales as multiple lines. I would like to subtract each line item from a fixed line but don't know how to do it. eg. subtracting each month's sales from the monthly target number of 100.

       

      Product Name        Date            Monthly Target          Sales      Delta (Result I'd like to get)

      Product A             1/1/2013                   0                    20               100-20=80

                                  2/1/2013                   0                    10               100-10=90

                                  3/1/2013                   0                    40               100-40=60

                                  1/1/2014                 100                  0                100-100=0

       

      Product B             4/1/2013                   0                    70               100-70=30

                                  5/1/2013                   0                    30               100-30=70

                                 6/1/2013                    0                    40               100-40=60

                                  1/1/2014                 100                  0                100-100=0