6 Replies Latest reply on Dec 14, 2018 12:55 AM by Veera Veeru

    How to calculate YTD & Full Year ?

    Veera Veeru

      Hi,

       

      Can anyone help me with the below query ?

       

      I have a dimension called "Period" which contains "Jul'17 to Jun'18" and measure "Actual". Using this information, i would like to get MTD, YTD and Full Year, using calculations.

           

      Example: When I select "Mar'18" from the dimension "period" I should get the values of only "Mar'18" in MTD, and i should get the values added from "Jan'18" to "Mar'18" in QTD since they are in 3rd Quarter,  and  I should get the values added from "Jul'17" to "Mar'18" in YTD i.e. Mar'18 to selected month of a year.

       

      I need to use Parameter to select between MTD, YTD and FY.

       

      Thanks in Advance.