12 Replies Latest reply on Sep 5, 2017 9:50 PM by Shinichiro Murakami

    Show Previous Quarter values based on Time period dynamically

    vasu.choudhury

      I want to display previous Year/Quarter/Month values based on Time period selection dynamically. Attached the sample dashboard.

       

      In 2017 Q2, for M-20, we have 100%

      2017 Q1, for M-20, we have 75%

      2016 Q4, for M-20, we have 60%

       

      Requirement:

      Time Period filter -->  2017 Q2, 2017 Q1 & 2016 Q4

      When 2017 Q2 is selected, I need to display as.... M-20     100%     75%

      When 2017 Q1 is selected, I need to display as.... M-20     75%       60%

      When 2016 Q4 is selected, I need to display as.... M-20      60%     N/A

       

      I don't want to show it in a separate sheets with hard coded values and want it dynamically and satisfies this condition even if new extract happens.

       

      Appreciate your help!