topic What would be the simplest way to enable users to pick two nonsequential months and compare various measures (volume, revenue, etc.) in a pivot table? in App Development

What would be the simplest way to enable users to pick two nonsequential months and compare various measures (volume, revenue, etc.) in a pivot table?

NenadV — Wed, 16 Nov 2022 14:22:23 GMT

Hi,

For using comparisons year-on-year, the same month, or quarter or year) I use these expressions:

Previous year: sum({$<Year={$(=Year-1)}>} Qty)

Current year: sum({$<Year={$(=Year)}>} Qty)

What to use if an user selects November vs March?

Any idea?

Thanks a lot

Re: What would be the simplest way to enable users to pick two nonsequential months and compare various measures (volume, revenue, etc.) in a pivot ta

Or — Wed, 16 Nov 2022 14:27:58 GMT

How exactly has the user selected this? That would impact the solution...

You could use alternate states to allow two independent comparison periods to be selected (they don't have to be any specific length, or even the same length). If the period length is always one month, you could use a set to get the max(Month) and Min(Month) for the comparisons, respectively.

Re: What would be the simplest way to enable users to pick two nonsequential months and compare various measures (volume, revenue, etc.) in a pivot ta

NenadV — Wed, 16 Nov 2022 14:52:23 GMT

Yes, I've been thinking about Alternate states and was not sure if I can use them in a single pivot table. I'll take this route and get back with the outcome.