2 Replies Latest reply: Jun 1, 2009 4:43 PM by LawhornB RSS

    How to displaying Year-to-date chart line based on monthly data

      I am attempting to build chart with a line for each year where the lines represents the accumulated YTD revenue for each month. (The resulting lines generally increases each month as the new month's revenue is included)
      The input needs to be the 'SUM(Revenue)' for each =DATE(Date, 'MMM YY') across multiple years. If this is possible please provide the expression to be used in the chart expressions.