Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a pivot table with 3 dimension and 1 expression my goal is to have the sum of "valore" in R2 group (ok) and the cumulative sum in R1 group. In the test file i would like that the value in R1 group "MARGINE COMMERCIALE" is the sum not only of the appropriate group but even of the previus group "MARGINE DIRETTO".
In the same way, the "MARGINE OPERATIVO LORDO" i would like that is the sum of the previous "MARGINE DIRETTO" , MARGINE COMMERCIALE group and MARGINE OPERATIVO LORDO group.
This is only a small part of the ricorsive sum
Thank
Enrico
Try this:
=If(Dimensionality() <> 1, Sum(VALORE), Aggr(RangeSum(Above(Sum(VALORE), 0, RowNo())), R1))
Is this the goal?
I used this:
RangeSum(Above(TOTAL Sum(VALORE), 0, RowNo(TOTAL)))
Not exactly. The cumulative sum that i want is a cumulative sum ONLY of group R1, see below where i put the goal value in E column and the excel formula in F column
Try this:
=If(Dimensionality() <> 1, Sum(VALORE), Aggr(RangeSum(Above(Sum(VALORE), 0, RowNo())), R1))
Perfect!!!
Thank you!
I am glad I was able to help, but it would be better if you can mark the response which actually helped you get what you wanted, instead of marking your own response here.
Best,
Sunny
Yes, sorry
Marked the correct answer.
Thank you again.
Best
Enrico
Thank you