pivot table with rangesum

agigliotti — Tue, 09 Jan 2018 11:33:30 GMT

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

Re: pivot table with rangesum

marcus_sommer — Tue, 09 Jan 2018 11:43:09 GMT

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

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

- Marcus