8 Replies Latest reply on Oct 29, 2018 5:54 AM by Shinichiro Murakami

    How can i show current year and previous year YTD calculations with Parameter (Selected Months)?

    Yavuz Temucin

      Hello,

       

      I want to create a dashbaoard with month selection (parameter).

       

      When i select the month i should show current month, previous month and last year same month values. Also It should show me current year and previous year ytd values (cumulative) again with month selection. Everything should change just month selection (parameter).

       

      I managed current month, previous month, and last year same month values

       

      if ([Date] >= dateadd('month',-1,[Select Month])

          and [Date] <dateadd('month',1,[Select Month]) )

      or ([Date] >= dateadd('month',-12,[Select Month])

          and [Date] <dateadd('month',-11,[Select Month]) )

      then [Date] end

       

      But i couldn't handle ytd calculation. Could you please help?

       

      You can find the report view and file below.

       

         

      MTDYTD
      LY (previous year month)M-1MLY (previous year)CY (current year)

       

      Thanks.