Comparison of Current Qtr with previous qtr based on selection in pivot table

sunainapawar — Sat, 16 Nov 2024 17:25:38 GMT

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.

Re: Comparison of Current Qtr with previous qtr based on selection in pivot table

sunainapawar — Thu, 04 Mar 2021 04:44:39 GMT

Hello All,

Any idea on this.

Thanks in advance.

Re: Comparison of Current Qtr with previous qtr based on selection in pivot table

sunainapawar — Mon, 22 Mar 2021 10:43:24 GMT

Hello All,

I solved this by using Alternate States.

Thank you

topic Re: Comparison of Current Qtr with previous qtr based on selection in pivot table in App Development

Comparison of Current Qtr with previous qtr based on selection in pivot table

Re: Comparison of Current Qtr with previous qtr based on selection in pivot table

Re: Comparison of Current Qtr with previous qtr based on selection in pivot table