last but one year

[#1]

Hi i have  requirement like displaying sales of  last but one year not current year-1.

year field is like 2014 and 2011 and 2008 like this not in order .

[Nicole-Smith · Accepted solution]

You can find the second highest year by using:

max(Year, 2)

So to sum sales, something like:

sum({<Year={$(=max(Year, 2))}>}Sales)

[hic]

In the script, in the master calendar you should define a flag for last year:

  If( Year(Date) = Year(Today())-1, 1, 0) as IsLastYear,

Then you can use this in a Set Analysis expression:

  Sum ( {$<IsLastYear={1}>} Amount )

HIC