if condition for sum rows

[chrissyp]

Hello everyone,

i try to sum rows in a pivot table with if condition.

MY data look like

Zeilennr     Konto     Betrag

1                  4677     20

2                   4711     50

3                    -          (20+50)

4                    4855     80

5                    -            (20+50+80)

so i want something like if(zeilennr=3, sum (betrag of zeilennr 1 and zeilennr 2)

and for zeilennr 5  if(  zeilennr=5, sum (betrag of zeilennr 1 and zeilennr 2 and zeilennr 4)

can anybody help

thx

chrissy

[ogautier62]

Hi,

so you want a cumulative sum  do you ?

you could look at functions above() or before() with rangesum

regards

[chrissyp]

I just want a cumulative sum for zeilennr 3 and 5 zeilennr 1, 2 and 4 just should be the normal sum