Formula or chart help - Crystal Reports 1

[DozAdmin]

I want to display info in a bar chart, I'm not sure if I need a different formula or more understanding on creating a chart.

The data I want to display is how many people are participating in an event by age group, I would also like the total participating.

I created a formula to group by age 18-39, 40-59, 60 and up.

I can display this in the chart but I want to add the total particpating and when I add that, the chart only looks at the total.

If this is a formlula issue, how do a create a formula to show total, with the groups?

I think I'm missing something obvious.

 

[Madawc]

Group using the formula. Then it should let you chart using the total - I think.

It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

It might be easiest to create a second chart just with the total, overlaying this over the first, and making various elements of the second chart transparent. Of course, you would have to ensure that the Y axis was the same in both charts.

Otherwise, depending upon your version, you could create a formula like this:

if maximum({@age},{@agegroup}) = maximum({@age}) then
distinctcount({table.personID})

Add this as your first summary field with "do not summarize" checked. Then go to the "on change of" field and highlight it->topN and choose a sort on this formula. This would add the total summary on the right or left, depending upon your sort order. Problem is that it will be clustered with one element of the second summary, rather than being equidistant visually.

-LB