Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Perhaps like this:
If(Dimensionality()=0,Sum(TOTAL),
if([Fiscal - Flag Current PTD]='Y',
RangeSum(Above(
TOTAL
Column(1),
0, RowNo(TOTAL))))
)
Perhaps like this:
If(Dimensionality()=0,Sum(TOTAL),
if([Fiscal - Flag Current PTD]='Y',
RangeSum(Above(
TOTAL
Column(1),
0, RowNo(TOTAL))))
)
That didn't seem to impact the total at the bottom unfortunately.