Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.