Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a pivot table and I wish to get a running total.
When I use the following RangeSum(Above(sum(MeterTarget),0,ColumnNo())) all I get are zeros as shown below.
great . it worked.
Please accept solution and close this it will help to others .
Try this
RangeSum(Above(sum(MeterTarget),0,RowNo())) function instead of ColumnNo().
This should give you a running total across all rows in the pivot table.
Hi Chanty4u, as per your suggestion, I have changed the formula to include RowNo(), however, I still get zeros
May be check below things
Check the data model: Verify that the MeterTarget measure is correctly defined in the data model and is being aggregated using the sum() function.
Check the dimensionality of the pivot table: Ensure that the pivot table has the correct dimensionality for the running total to work. For example, if you want to calculate the running total by month, make sure that the month dimension is included in the pivot table.
Hi Chanty4u, thanks for your comments, especially about month dimension.
I have used the following and it works
Aggr(RangeSum(Above(sum(MeterTarget),0,RowNo())),WeekCommencing).
great . it worked.
Please accept solution and close this it will help to others .