3 Replies Latest reply: Dec 12, 2016 7:15 AM by Sunny Talwar RSS

    YTD Calculation for Weekly Dashboard

    Ishan Bansal

      Hi Experts,


      I have a situation where

      Data set has been attached ***


      Week and year are the filters

      1st dashboard

      gender is the dimension and count(age_group) is the measure


      Now, when i select week and year from the filter i get details of that week.

      But now as per the requirement i want the YTD values for the same


      so if i am selecting week 6 and year 2016

      i should get the values from week count(week1 till week6) of 2016   ( Basically the YTD)


      Please suggest.