-
1. Re: how to use same filter differently across multiple worksheets
aditya.wresniyandaka Apr 5, 2017 9:43 AM (in response to Nitin Agrawal)On the Filter on the dashboard, select "Apply to worksheets", either choose All Using This Data Source, or Select Worksheets and specify which worksheets you want to be included in the filter. Please see the attached modified workbook; I added the Year and Month so you can see how it works when you select different values on the filter.
-
sample.twbx 40.4 KB
-
-
2. Re: how to use same filter differently across multiple worksheets
Nitin Agrawal Apr 5, 2017 9:53 AM (in response to aditya.wresniyandaka)Thanks for the reply Aditya however if i use 'apply all' then i wont get the data for 3 months in sheet 2. In any case i want atleast 3 months of data in sheet 2.
Now from your solution if i select filter as Feb 2017, then only 1 month of data is showing in dashboard.
However i want data for 3 months i.e Dec 2017, jan 2017 and Feb 2017 in trend worksheet(sheet 2) for Feb 2017 filter selection.
Thank you.
-
3. Re: how to use same filter differently across multiple worksheets
aditya.wresniyandaka Apr 5, 2017 11:21 AM (in response to Nitin Agrawal)HI Vicky - I am sorry I missed that part of your question. Hmm... that is tricky. Basically what you are trying to do is: based on the selected period/date, display the last 3 months including the selected month. I don't think there's a built-in function in Tableu to do that; I am afraid you will need to use a parameter, like mentioned in this article:
Creating Relative Date Filters with Adjustable Anchor Dates | Tableau Software