3 Replies Latest reply on Jan 4, 2018 12:26 PM by arvindgarg

    Date Calculation

    Mithun Shanmugam

      I have a requirement where, i need to create a dashboard with YTD data but that year to date should be the previous months of the YTD. Can anyone help me with the formula.

       

      Reporting MonthNov '17Dec '17Jan' 18Feb '18Mar '18
      Data to include - YTDJan'17 - Oct'17Jan'17 - Nov' 17Jan'17 - Dec'17Jan' 18Jan'18 - Feb'18