How to Select The Last two selected from a list

Mon, 12 Mar 2012 13:12:41 GMT

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.

Re: How to Select The Last two selected from a list

swuehl — Mon, 12 Mar 2012 13:23:33 GMT

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)