2 Replies Latest reply: Oct 8, 2013 2:05 AM by vikas mahajan RSS

    Monthly accumulated values

      Hi all,

       

         I've been trying to put up a chart with the accumulated values by month and I've been wondering if there's any expression to do this for me, so I don't need to place this info in the datasources. Ok, in more detail now. I have a table with the following info:

       

      • Month;
      • Product Name;
      • Sales Value.

       

         What I want in the end, is a chart where I can see the total sales value accumulated by month. Meaning, in the first month is the value of the sales themselves, the second month the sales of the current month plus the ones of the month before, and so forth. In the end this chart should look something like the one in attach.

       

         Does someone know of any function to do this automatically?

       

      Thanks,

      André