6 Replies Latest reply on Nov 11, 2018 9:56 AM by Arunaa Ramakrishnan

    Dynamic YTD calculations based on month selection without using parameter

    Arunaa Ramakrishnan

      Hi,

       

         I have my data having date related fields say Order Year and Order Month and Sales Measure. Order Year and Order Month are filters and users can select the year and month they want.

      I don't have any parameter selection in my dashboard.

       

      Is it possible to calculate dynamic YTD based on the year and month selection? Like If I select April 2018, YTD should be sum of Sales from Jan 2018 to April 2018. If I select June 2018, then YTD should be Sum of Sales from Jan 2018 to Jun 2018.

      I know with Parameter, it is easy to compare Order Year and Order Month with the selections. But without parameter, using only filters, is it possible to do like this?

       

      Can someone help please?

       

      Thanks,

      Arunaa