pivot table with rangesum

[agigliotti]

Hello,

Does is possible to have an expression total (for column) using the below expression:

rangesum( before( sum(sales), 0, RowNo() ) )

as accumulate measure over months ?

for example how to have total for jan, feb etc... ? now I'm getting 0.

many thanks in advance.

best regards

Andrea

[marcus_sommer · Accepted solution]

Try it with NoOfColumns() if you want to accumulate columns maybe with something:

rangesum( before( sum(sales), 0, NoOfColumns(TOTAL)))

- Marcus