5 Replies Latest reply on May 6, 2013 5:25 AM by Brad Llewellyn

    YTD Calculation without Previous Months Showing

    Chandra Shekhar Jain

      Please see attached sheet.

       

      The line is the YTD Sales restarting in each year.

      The color of the line is indicative of the % change over the YTD Sales of the same month in the Previous Year.

       

      I would like to know if it would be possible to show the same view with only the previous two months relative to today's date.

      i.e if the current date is may 3 2013 i only see data for Mar , April and May in both 2013 and 2012.

      Can this be automated or should I have to use Month filters.  Also when I exclude the other months my YTD Sales continues to be the same and doesnt restart from zero in the first visible month.

       

       

      Chandra