4 Replies Latest reply: Apr 7, 2017 3:22 AM by Beck Bakytbek

# Show only 3 FY trend

HI Experts!

I would need help showing a 3 FY trend.

Here, it is showing me 4 FY trend, which is what I have in my excel data. Now I only want to  show 3 FY ( Current FY and pas 2 FY)

I have a data columns in my excel telling me which fiscal year it is. (FY14,FY15,FY16,FY13,etc).

Thank You

~Jia sheng

• ###### Re: Show only 3 FY trend

Hi,

Do you have any Year field? (without the FY word). If yes, you can do a set analysis like this:

sum({<Year={'>=\$(=max(Year)-2)'}>} Value)

This will get the year that is greater than the max year minus 2 years.

Now if you want to get the current year (Today()) minus 2 years (FY17,16,15)

sum({<Year={'>=\$(=max(Year(Today()))-2)'}>} Value)

• ###### Re: Show only 3 FY trend

Hi Yddona,

I do not have a year field (without any FY word). I wanted to use something like this: fyear = {">\$(=Max(fYear)-3)"}.

However it only works with numeric field.

• ###### Re: Show only 3 FY trend

If you want the current year, you can use the Today() function.

Do you have any date field? If really don't have, I recommend you create your own Year field to identify numerically the FY.

• ###### Re: Show only 3 FY trend

Hi Jia,

try this:

if (aggr(rank(Sum(Your Value)), FY) <= 3, FY, Null()) and forget to surpress the Null-Values

i hope that helps

beck