I would like to create a bar chart from this report source;
Monthly BBB OCC CFPB
2014-12 1 2 2
2014-11 4 1 2
2014-10 2 1 1
Other month
12 Mnth AVG 1.5 5.8 7.4
I have 12 months and the summary in the detail section.
The chart has to have the last months which is not included in the summary I filter 2015-01 to got that. But, the values has to be part of the chart. Just the current month in this case 2015-01 and the summary for the avg. have to be the values in the chart. I did an e.g. in excel. I would like to do the same in Crystal.
SOURCE Current Month 12MnthAVG
BBB 0 1.7
CFPB 10 7.2
OCC 5 5.9
Sorry, I tried to paste the chart;but, I can't
You will figure it out
Thank for you help in advance
Rodolfo