Running Total Pivot table

[MikeJones]

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.

[Chanty4u]

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.

[MikeJones]

Hi Chanty4u, as per your suggestion, I have changed the formula to include RowNo(), however, I still get zeros

[Chanty4u]

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.

[MikeJones]

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).

[Chanty4u · Accepted solution]

great . it worked.

Please accept solution and close this it will help to others .