6 Replies Latest reply on May 4, 2020 12:16 PM by Lakshey Kwatra Branched to a new discussion.

    MTD YTD using week number for provided fiscal calendar

    Lakshey Kwatra

      Hi, I am trying to get current year MTD/YTD and last year MTD/YTD using the week offset number provided. When week Offset is 0 then it is current week/month/year of Fiscal calendar..

      I was able to get MTD using LOD (snapshot below) however I want it to say "MTD" instead of month number. I tried "MTD" after THEN but LOD needs aggregated value.

       

      Similarly I wanted to get YTD, Last year MTD/YTD but couldn't get it right. Could someone please help?

       

      Attached the workbook for reference.