4 Replies Latest reply on Nov 10, 2015 10:24 AM by Raghu Anisur

    Fiscal YTD and Fiscal Week  from the Calendar Date or Calendar Week

    Raghu Anisur

      Hi Tableau Gurus,

       

      I have a date "Week Date" this is based on the Calendar Year.And I derived the Year ,Quarter, and Month from this Calendar Date.

       

      This Week date is the  Calendar Week but I would want to create the Fiscal Week based on the calendar week. I guess once I create the Fiscal week , then deriving the Fiscal year and fiscal quarter and fiscal month is easy from there.

       

      Again How would I derive the Fiscal YTD from the FY and FM, FQ.

       

      Any ideas on this greatly helpful.

       

      Regards,

      Anisur