Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm facing an issue about rangesum function in a Pivot table,
I calculate a cumulative amount like this
The expression:
if((Dimensionality())=1,
rangesum( sum( aggr( rangesum( above( Sum( {$<expr>} Amount) ,0,rowno(TOTAL) ) ) , Dimension 1 ) )
, sum (Amount)
I have 2 dimensions:
Dimension1 diplayed in rows and Dimension2 displayed in Columns.
This is how we want to display the pivot table:
Dimension1 | Dimension3 | Dimension4 | Dimension2 | Z1 | Z2 | Total |
A | A1 | 10 | 20 | 30 | ||
A | A2 | A21 | 1 | 3 | 4 | |
A | A2 | A22 | 1 | 2 | 3 | |
A | A2 | A23 | 2 | 4 | 6 | |
A | A2 | A24 | 1 | 5 | 6 | |
A | A2 | Total | 4 | 14 | 18 | |
A | Total | 14 | 34 | 48 | ||
B | B1 | 2 | 3 | 5 | ||
B | Total | 16 | 37 | 53 | ||
C | 17 | 38 | 55 | |||
D | 18 | 39 | 57 | |||
E | 19 | 40 | 59 | |||
F | F1 | 1 | 2 | 3 | ||
G | Total | 20 | 42 | 62 | ||
Total | 20 | 42 | 62 |
And for the moment I have this:
Dimension1 | Dimension3 | Dimension4 | Dimension2 | Z1 | Z2 | Total |
A | A1 | 10 | 20 | 30 | ||
A | A2 | A21 | 1 | 3 | 4 | |
A | A2 | A22 | 1 | 2 | 3 | |
A | A2 | A23 | 2 | 4 | 6 | |
A | A2 | A24 | 1 | 5 | 6 | |
A | A2 | Total | 4 | 14 | 18 | |
A | Total | 34 | 0 | 34 | ||
B | B1 | 2 | 3 | 5 | ||
B | Total | 53 | 0 | 53 | ||
C | 55 | 0 | 55 | |||
D | 57 | 0 | 57 | |||
E | 59 | 0 | 59 | |||
F | F1 | 3 | 0 | 3 | ||
G | Total | 62 | 0 | 62 | ||
Total | 62 | 0 | 62 |
Does anyone has any idea on how I could fix this issue?
Many thanks,
Nacera
Ce message a été modifié par : nacera abbas
Which null? The one I mentioned above in my post?
Yes, those ones.
I tried to add fictif rows with zeros but I can't imagine all cases to do that
Best way is to generate missing data in the script
Thank you, I will take a look at this