CR X: Bar chart with "growing" bars

[BarbaraFuhrmann]

Hi,

I have the instruction to create a report with two bar charts that shows the development of a value in the month of a year.

First chart shows the sum per month, that means e.g.:
Jan - 10
Feb - 5
Mar - 8
etc.
That one was easy, I created it with the diagramm expert using "on change of: {@month}" and "show value: sum of {@value}".

Secon chart shall show the combined value, that means for the above example:
Jan - 10
Feb - 15
Mar - 23
etc.
Is there any option or perhaps a special chart template to realize that?

Thank you for every hint!
Barbara

 

[paulmarr]

Hi Barbara,

I think the only way to do what you are suggesting is to base the value on a running total instead of the Sum(@value).

Cheers
paulmarr

 

[BarbaraFuhrmann]

Hi paulmarr

I tried that, but when I build a simple running total and put it in the chart its value is the december value for all displayed month.
When I create 12 running totals (one for result of Jan, one for Jan+Feb, one for Jan-Mar, and so on) I don't know how to tell the diagramm expert to use this values.

Any ideas?

Barbara

 

[lbass]

Try this. First create a formula {@all}:

whilereadingrecords;
""

Use this as your "on change of" field in the chart, and then you should be able to add the running totals to the chart, without summarizing them. The chart belongs in the report footer.

I don't know why CR XI doesn't allow "For all records" with unsummarized running totals, but it doesn't seem to.

-LB