2 Replies Latest reply on Jun 27, 2018 12:14 AM by An Na

    Creating a YTQ Calculation based on the Financial Year

    An Na

      Hi all,

       

      i created the following dashboard and my goal is to show on the left side a Quarterly view and on the right side a FY view but based on the quarters.

       

      On the left side the user can see the YTQ calculation for each segment in a stacked bar.

      On the right side there should also be the YTQ calculation but without the Quarters in the Axis. It should be like this:

       

      If the User selects Q1, it should show Q 1

      If the User selects Q2, it should show Sum of Q1+Q2

      If the User selects Q1+Q2, it should show Sum of Q1+Q2 and so on.

       

       

      In my current view the calculation doesn't work in the right way.

       

      Is there a way to create this kind of view? Please find a workbook attached.

       

      Thanks a lot.

       

      Best,

      Anna