Chart with cumulative total

V

Violaine

Hi there,
I've been trying to create a chart showing, per month, the different
production loss types (shut down loss, production adjustment, etc), total
downtime per loss type, and cumulative total downtime (pareto chart).

I want to have a bar chart with
- total production downtime per loss type, in descending order (loss type in
axis)
- a line showing the cumulative total downtime

I started with a query (Date per Month/ Loss Type / Sum of Downtime). Then I
added a chart based on this query in a report.

But how can I have the cumulative total downtime??? I created a running sum
box in my report, I would need to have that information in the chart as
well...

Could you help me to figure out how to build that?


Thanks a lot!
Violaine
 
Top