Hello All,
I have a requirement. I have a pivot table. Dimension is customer. And measures are current and previous qtr. I need to show growth and degrowth based on qtr selection.
By default ,the growth must be shown as current qtr-prev qtr but when someone selects a quarter then it must dynamically compare the selected qtr with previous qtr. Or if someone selects a current qtr of current fyear,then it must compare the same quarter of last fyear and show the growth between them. I tried below expression but it is not working.
Current qtr
If(getselectedcount(qtr)=0,//for default selection
Sum({<quarter='$(vcurrentqtr)',sum(amt),
If(qtr=getfieldselection(qtr),
Sum({<qtr={"=$(getfieldselection (qtr))"}>}amt ))
Here currentqtr is the lastest qtr.
Same expression I have used for previous qtr. But on qtr selection, both previous and current are showing same values
Kindly help.
