Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the expression meaning?Please give an example.
RangeSum(before(COUNT(PolicyCounter),0,ColumnNo()))
This expression will sum every value into COUNT(PolicyCounter) from first column until current one
This expression will sum every value into COUNT(PolicyCounter) from first column until current one
hi Aretha,
it calculates the cumulative sum of counts in pivot table.
in chart or a straight table you would use "above" instead of "before".
hope that helps
Please explain with this example
Load * INLINE [S.No,PolicyCounter
1,2
2,12
3,34
4,89
5,80
]
It seems like an expression used in a pivot table where you are accumulating based on your pivoted dimension. So assuming S.No as your dimension, you will get something like this.
S.No 1 2 3 4 5
ExpResult 2 14 48 137 217