What is the expression meaning?

[arethaking]

What is the expression meaning?Please give an example.

RangeSum(before(COUNT(PolicyCounter),0,ColumnNo()))

[Clever_Anjos · Accepted solution]

This expression will sum every value into COUNT(PolicyCounter) from first column until current one

[Frank_Hartmann]

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

[arethaking]

Please explain with this example

Load * INLINE [S.No,PolicyCounter

1,2

2,12

3,34

4,89

5,80

]

[sunny_talwar]

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