Cumulatives in graph

acm · November 19, 2010 3:02PM

Hi there, I need to show cumulative sales in a graph.
Data is volume per product per week. I need the cumulative volume per product over all weeks that have past.

Product|Week|Volume|Cumulative
A|1|5|5
A|2|10|15
B|1|3|3
B|2|8|11
A|3|6|21
C|2|2|2

The Product-Week combination is unique.

Does anyone know how to calculate the cumulative column dynamically in Data Manager?

steve · November 23, 2010 11:38AM

Please see attachment. I'm not using DataManager, but you could equally well apply the same formula (via copy and paste) in a DataManager Field Organiser block.

I've also shown the use of the Bar view to show the same cumulative sales using cascading bars, without requiring a formula or dedicated "cumulative" field.

Note that the cumulative sum does not make sense if you filter the data and omit weeks from the result. You will still see the cumulation over the original full dataset.

acm · November 23, 2010 12:12PM

Steve, thanks so much for your help.
Had a quick look and it seems exactly what I need.
Will test on my dataset when I can.

The cascaded bar option is one I thought about as well, but is not as strong as a cumulative graph with targets in it (regions)

Appreciate your help

steve · January 26, 2011 6:29AM

Note that the new RUNNINGTOTAL formula function is now available in 2.6 b502.

Welcome!

Categories

Ideas Parade