5 Replies Latest reply: Jan 19, 2012 8:15 AM by Carlo A. Babini RSS

    Chart with total sum and running sum

      Hi all,

      I am facing a strange problem in a chart: I need to show the difference between sales and costs, by month. Now the strange problem is that sales are running sum while costs are puntual per month, so I think that I have to calculate the running sum of costs by month, but month is the dimension of my chart.

       

      here an example of the database:

      SALES

      JAN 1000

      FEB 2500 (1000+1500)

      MAR 3400 (1000+1500+900)

      ....

       

      COSTS

      JAN 800

      FEB 1100

      MAR 600

      ...

       

      This is driving me mad, thank you in advance for spending time on this, and sorry for my poor english.

       

      Carlo A. Babini