Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Suppose i have a list of Month like: Jan, Fev, Mar, Apr, Mai, ... , Dec
and
Suppose that the user has selected Fev, Apr and Dec.
And then i have a table that shows
Sum({<Month={'=Max(Month)'}>} Sales) / Sum({Month={'=Somenthing to get Max(Month) - 1 from the Selection'}>} Sales)
How can i get the last but one (penultimate?) user selection?
Thanks in advance.
You can specify the rank as second parameter to max() function.
max(Month,2) will return the second highest Month
So maybe use something like
Sum({<Month={'$(=Max(Month))'}>} Sales) / Sum({Month={'$(=Max(Month,2))'}>} Sales)
You can specify the rank as second parameter to max() function.
max(Month,2) will return the second highest Month
So maybe use something like
Sum({<Month={'$(=Max(Month))'}>} Sales) / Sum({Month={'$(=Max(Month,2))'}>} Sales)