Line chart for details and summary - URGENT

[jenfromjax]

Hi everyone.

I am using Crystal Reports v10. The Sales Dept wants a line chart that shows:

Sales Types: New & Add-on
Y axis: Millions
X axis: Months

I had the above in a cross-tab and no problem creating the chart for this. But now they want to include a line for the totals row. So the chart would display:

Ex:
Total for New sales in Jan, Feb & Mar
Total for Add-on sales in Jan, Feb & March
Combined total for Jan, Feb & Mar

Is this possible? If so, HOW?! Please let me know if you need additional info.

 

[jenfromjax]

I figured it out. Here's what I did in case anyone ever needs to do this (Reminder: Crystal v10). It's not pretty, but here goes...

Group on {ContractDate} by Month

Formula #1 (@Add-on)
If {CustomerType} = "Add-on" then {TotalSales}

Formula #2 (@Nau)
If {CustomerType} = "NAU" then {TotalSales}

Then, I inserted @Add-on, @NAU & {TotalSales} into the details section. Created a running total for all three & inserted them into the Group Footer. Tip: If you want to see a total for each by month, reset your running totals on change of Group. In my case, they want to see cumulative numbers for each type so I never reset the running total.

Next, I inserted a line chart (uncheck the "Automatically set chart options"). Click the Data tab, type of layout is "Advanced", "On change of" {ContractDate} by month and "Show value(s):" #Add-on, #NAU, and #TotalSales.

That's about it. If anyone has a better idea, please let me know. Hope this helps someone after all of the awesome tips I've gotten from here.

Jen )