I am using the expression
RANGESUM( Before( sum({<YTDFlag={1}>}SalesAmount), 0, 3) )
My table looks like
Department YTD PYTD
d1 xxxx xxxx
d2 xxxx xxxx
The pivot table shows only nulls because the before() function fails to retrieve results which makes sense. Is there anyway around it? I tried above and that didn't do anything either.
Is there any other inter-record function that could make it work in the expression? Thanks for your help folks!