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.