Totals Not Calculating in Pivot Table

[uko223]

Hi, 

I have a pivot table that uses rangesum to calculate a cumulative sum based on column 1 and column 2. However, the subtotal based on the "Date" dimension is not calculating any of the rangesum measures.  The rangesum measure I am using for CY WTD is below.

if([Fiscal - Flag Current PTD]='Y',
RangeSum(Above(
TOTAL
Column(1),
0, RowNo(TOTAL))))

Any ideas how to get the total to display the total amount for the CY WTD column based on the Date dimension?

[Gysbert_Wassenaar · Accepted solution]

Perhaps like this:

If(Dimensionality()=0,Sum(TOTAL),

if([Fiscal - Flag Current PTD]='Y',
RangeSum(Above(
TOTAL
Column(1),
0, RowNo(TOTAL))))

)

[uko223]

That didn't seem to impact the total at the bottom unfortunately.