Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chrissyp
Partner - Contributor II
Partner - Contributor II

if condition for sum rows

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

2 Replies
ogautier62
Specialist II
Specialist II

Hi,

so you want a cumulative sum  do you ?

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

regards

chrissyp
Partner - Contributor II
Partner - Contributor II
Author

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