Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
agigliotti
Partner - Champion
Partner - Champion

pivot table with rangesum

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

1 Solution

Accepted Solutions
marcus_sommer

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

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

- Marcus

View solution in original post

1 Reply
marcus_sommer

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

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

- Marcus