Need help from experts for the below problem:
I have two filters with following values
1. Filter 1: Quarterly, Weekly
2. Filter 2: Actual Value depending on the Filter 1
For example: If I select 'Quarterly' from Filter 1, then Filter2 should be populated with 'Distinct Years' from the table (say A) eg. 2009,2010,2011
If I select 'Weekly' from Filter 1, then the Filter2 should be populated with 'Distinct Quarters' from the table (say A) eg. 2009Q1, 2009Q2, 2010Q1 etc...
Take the case that Table A is connected live and I have both the dimension 'Year' and 'Quarter' available in the page.
Can somebody please help on how to achieve this?
Depending on how things are set up, this should be doable (perhaps with Parameters instead of just filters). Instead of trying to guess how your data and workbook look, would you be able to post a sample workbook?