6 Replies Latest reply: Mar 19, 2013 6:56 AM by oeztuerk78 RSS

    RangeSum

      Hello,

       

      I use the following function

      RangeSum(Above(TOTAL Sum(turnover), 0, ROWNO(TOTAL)))

       

      The result look like this in a pivot table:

       

      Dimension I          Dimension II          turnover          rangesum turnover (wrong)      rangesum turnover (want to have this result)

      A                         KW01                   1000                1000                                1000  

      A                         KW02                    5000               6000                                 6000

      A                         KW03                    8000               14000                              14000

                                  TOTAL                  14000               0                                       0 

       

      B                         KW01                    2000               17000                              2000

      B                         KW02                    1000               18000                              3000        

      B                         KW03                    4000               22000                              7000

                                  TOTAL                  7000               0                                       0 

       

      How can I handle it, that the accumulation start from the beginn, when the group changed it?

       

      Many thanks !