How to Select The Last two selected from a list

[#1]

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.

[swuehl · Accepted solution]

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)