Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

cumulative sum in line in pivot chart

Hello Guys,

i hope you can help me.

I want to cumulate in a Line in a 2 dimension pivot chart.

pivot.png

Example :

     x                    y                    z

a [] 2953 | 2953 [] 2407 | 5360 [] 2187 | 7547

Regards,

Lukas

2 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

Here you go

Luis_Cortizo
Former Employee
Former Employee

Something like this, I guess:

Number 1 2 3
Letter Amount Amount Acc Amount Amount Acc Amount Amount Acc
A 456 456 234 690 712 1402
B 98 98 236 334 43 377
C 761 761 21 782 2 784

I have two expressions:

Amount:

Sum(Amount)

Amount Acc:

rangesum(Sum(Amount), Before(Sum(Amount), 1,ColumnNo()))

I believe that that's what you're looking for