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.
Try it with NoOfColumns() if you want to accumulate columns maybe with something:
rangesum( before( sum(sales), 0, NoOfColumns(TOTAL)))
Retrieving data ...