Update chart based on List bax selection??

[soha1902]

Hi All,

I have one Year list box filter in my dashboard which shows the Fiscal Years.

In one of Pivot table I am displaying future stock of product in weekly basis and uses the standard date.

like below

Product	11/3/2014	10/3/2014	17/3/2014	24/3/2014	12/1/2014	12/8/2014	12/15/2014	12/22/2014	12/29/2014

Now the Problem is If I select 2014 from Year filter then it will showing 2014 and 2013 data in Pivot table, if I select 2015 then it is showing 2015 and 2014 data and so on. I want if select 2014 then in pivot table it will show only 2014 data and so on.

I want to do this in UI level only. Please help me to resolve this.

Thanks..

[Gysbert_Wassenaar]

Add a list box with an expression =Year(MyStandardDate) and make selections using that list box instead of using the Fiscal Year. Replace MyStandardDate with the name of your standard date field name.

[soha1902]

Thanks for your reply. In my application multiple tabs are available and I am using the same Filters in all the tabs, So can not change the Year field value in one tab only. Can you please suggest any other way to do this.