Hi there.
I am using CR XI against an Oracle database. The table I am reporting off of is :
Category, Month, Cost, Revenue
1A, Jan, 1.50, 1.75
1B, Jan, 1.25, 1.95
1A, Feb, 1.90, 2.25
The requirement is for a line chart with the month along the x-axis with the cost and revenue being shown for each Category. Therefore in January there would be two lines for Category=1A, one for Cost and one for Revenue.
When I try to do this I receive a msg informing me that a line chart should not have 2 groups and 2 values being shown. Has anyone any experience of doing this and if yes I would be grateful if you could share your experiences ?
Thank you for any assistance.
ShortyA
I am using CR XI against an Oracle database. The table I am reporting off of is :
Category, Month, Cost, Revenue
1A, Jan, 1.50, 1.75
1B, Jan, 1.25, 1.95
1A, Feb, 1.90, 2.25
The requirement is for a line chart with the month along the x-axis with the cost and revenue being shown for each Category. Therefore in January there would be two lines for Category=1A, one for Cost and one for Revenue.
When I try to do this I receive a msg informing me that a line chart should not have 2 groups and 2 values being shown. Has anyone any experience of doing this and if yes I would be grateful if you could share your experiences ?
Thank you for any assistance.
ShortyA