3 Replies Latest reply: Feb 17, 2017 12:16 AM by Jonathan Dienst RSS

    Values from the start till the week and year selected as a parameter

    Ishan Bansal

      Hi Experts,

       

      I have a scenario here and bit confused in solving these

       

      Till now i was calculating the YTD value , basically if i select week 4 and year 2017 then i will be getting the cumulative sum from week 1 till week 4 of 2017 and my expression was

      Count({<WEEK = {"<=$(=Max({<YEAR={$(=MAX(YEAR))}>} WEEK_M))"},YEAR = {"<=$(=Max(YEAR))"}>}Value)

       

      Now the current scenario is that if i select week 4 and year 2017 then the values displayed should be from the beginning of the data till the selected parameters ie till week 4 of 2017

       

      so if i have the data starting from week 01 and year 2014 and i have selected the parameters as week 4 and year 2017 the the value should be sum or count from week 1,2014 till week 4,2017

       

      Please suggest