9 Replies Latest reply: Nov 14, 2017 6:28 PM by Christian Song RSS

    Line chart accumulation

    Christian Song

      Hello,

       

      I'm trying to do a Line chart with 3 expressions: Actual expense, Budget, Forecast.

      The dimension is month.

       

      The budget and forecast are defined until December. The Actual expense is updated month to month and is an accumulation.(for instance: on October: the actual expense is the sum of from Jan to Oct. )

       

      When i put it  on the same chart line,  since Budget and Forecast have Nov and Dec data, so it's appeared on the chart. but for the actual expense,  Nov and Dec data is considered as 0, as result, the Oct number appeared on Nov and Dec, since it's an accumulation.

       

      I would like to not have Actual expense appeared on Nov and Dec, and Budget and Forecast keep the same.

       

      Any ideas for this?

       

      Thanks,