1 Reply Latest reply on Mar 26, 2012 9:41 AM by Andy Piper

    Dynamic value population in filter

      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?

       

      ~Deepak