Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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.
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.