RangeSum

[#1]

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 !

[#2]

Try with this:

RangeSum(Above([turnover], sum(turnover))

Where [turnover] is the expression name, and you should rename because is same that turnover field name.

Regards,

Ricardo

[er_mohit · Accepted solution]

Try this

RangeSum(Above(Sum(turnover),0,RowNo()))

[wizardo]

try this

RangeSum(Above(Sum(turnover), 0, ROWNO(TOTAL<Dimension I>)))

[#5]

Hi Mohit,

thanks a lot - it's work now right !

Regards,

Hülya

[#6]

Thanks for your help !

[#7]

Thanks for your help !