Monthly line chart where top 5 is based on YTD total

[teknogeek9]

CR XI here....

I have a crosstab report that displays the number of referrals by referral source, by month.
Jan Feb Mar Apr Total
Referral A 10 10 10 10 40
Referral B 9 9 9 9 36
Referral C 8 8 8 8 32
Referral D 7 7 7 7 28
Referral E 0 2 1 3 6
Referral F 0 3 2 0 5
Referral G 0 0 0 4 4
Referral H 1 0 0 0 1

I have the cross tab report display ALL referrals in the Total descending order by setting the top N value as high as necessary (100).

I need to create a line graph which shows the top 5 referrals based on the Total figures, not the monthly figures. In the above example, ABCDE would have their own individual lines and GH would be combined into "Others".

Is there a way to have the Total drive the displaying of the lines rather than the individual monthly amounts?

An example of where this is not doing what I would like would be the datapoints for Jan and Apr. I would like those datapoints to be the values of ABCDE. Instead, I am getting ABCDH in Jan and ABCDG in Apr.

 

[Dan3D]

If this is still an issue, you might want to check out our CRChart add-in product which has some TOTAL functionality you might find usefull.

-Dan

DISCLAIMER: I work for the company, threedgraphics.com, that makes this product. This product costs money.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com