Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
i hope you can help me.
I want to cumulate in a Line in a 2 dimension pivot chart.
Example :
x y z
a [] 2953 | 2953 [] 2407 | 5360 [] 2187 | 7547
Regards,
Lukas
Here you go
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