I need help with a Crystal Report. I am tracking the # of events reported by country per month with a chart. So I have a bar chart on change of Date1 (by month), followed by change of Country, which counts Events.
By simply using Running Totals, here is a sample of what I get for April of 2011:
Argentina = 5
Brazil = 8
Canada = 2
USA = 27
Australia = 7
France = 1
Algeria = 2
Now the problem: I would like to then place each country into 1 of 3 groups depending on the number of events reported, and then I would like to chart those three groups by month. So, the result would be three groups: group1 (<3 events), group2 (>3 and <5 events), and group3 (>5 events). For April of 2011, it would look like this. The chart does not need to list each country within each group, just show group1, 2 and 3 side by side for each month reported.
Group1 = 4 (Canada, Germany, France, Algeria)
Group2 = 1 (Argentina)
Group3 = 3 (Brazil, USA, Australia).
How can I do this?