Restricting Values

[naveen409]

Hi All,

I'm Having Data from APR-2016 to Till date.I created a Filter for MonthYear.

I'm showing Rolling 12 Months Data.But I want data from 2017 to Till data.

How to restrict 2016?

Your Suggestions Appreciated.

Thanks 

Regards,

Nani 

[gayathri_nagara]

Hi Naveen,
Create a variable and restrict the data from 2017 to Till Date.

[miskinmaz]

Use set analysis in the expression to exclude the year.

[naveen409]

Can You give me some Idea about this?

[HirisH_V7]

If you wan to restrict data in script then:
Put where condition like this,
Where Year(Date)>2017;

If in UI Level means,
Sum({<Date={">31-12-2017"}>}Sales)

[naveen409]

Is there any approach?

Actually I tried the below
Ex : Sum({1<Year={">2016"}>}Revenue)

[naveen409]

Yes HarishV,
If I did the set analysis, I can't Select any other Values from the filter. That approach is Static Not Dynamic.

If I will be Selecting APR-2018 It has to Show up to May-2017
In the same manner if I Will be Selecting APR-2017 it will be Show May-2016 Correct. Rolling 12 Months.

In the Rolling 12 Months I don't want to see 2016 data. Hope you understand the requirement.

Thanks for the Reply

[HirisH_V7]

Check this, 

=Sum({<Year-={"<2017"}>}Revenue)