8 Replies Latest reply on Feb 5, 2018 1:54 PM by rajesh reddy

    Trying to Calculate WTD,MTD,QTD,YTD

    rajesh reddy

      Hi All,

       

      I have a requirement where  

       

      Weekly, MTD(Month to date) are on a worksheet with Week filter

      Monthly, QTD(Quartet to date) are on a worksheet with Month filter

      Quarter, YTD (Year to date) are on a worksheet with Quarter filter

       

       

      Weekly ActualMTD Actual

           

      The actual is a value which will navigate to the current week and MTD will navigate till the week selected. On the same page.

       

      Eg: if w1 = 5, w2 = 6, w3=5,w4=6 etc, when I select week 1 in the filter then Weekly Actual should be 5 and MTD should be 5, when I select week 3 : the Weekly Actual should be 5 and the MTD Actual should be 16.

       

      Attached are the structure of the requirement in excel and extracted workbook in 10.4.

       

      Any suggestions and directions are invited.