3 Replies Latest reply: May 5, 2017 11:26 AM by neelam sehrawat RSS

    Set Analysis for YTD calculation for Select Year and Month?

    John Blomqvist

      Hi all,

       

      I am trying to create Set Analysis for an expression where I only want YTD values for the selected Year and Month.

       

      Fields names:

      Year: sample values, 2014, 2015, 2016, 2017, 2018 etc

      Month: sample values Jan, Feb, Mar, Apr, Jun etc

       

      Expression: Sum(Sales)

       

      So for example if I select Year 2017, and Month April, I want to see the total of Sum(Sales) to include Jan, Feb, Mar, Apr 2017 values added up together.

       

      If I select Year 2015 and July, it should be for all the months up to July 2015.

      And so on.

       

      Anybody know how to do this please?