Create chart from two values
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21455
Printed Date: 04 May 2024 at 1:06pm
Topic: Create chart from two values
Posted By: rlassalle
Subject: Create chart from two values
Date Posted: 27 Apr 2015 at 5:37pm
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
|
|