Skip to Content
0
Former Member
Nov 07, 2012 at 07:58 PM

Sorting a Bar Chart

44 Views

I'm using Crystal XI

I have a bar chart which lists salesstaff names for each bar and sales amount for the level of the bar. I want those with a specific region (a field in the database) for the bar and a "catch-all" of "Others" for those where the region is null or blank.

So far I have this and it works well. Except...

The bars are sorted alphabetically by the salesperson's name, which is ok. However the catch-all "Others" appears between Ned Newman and Paul Peterson. I would like the "Others" bar to be at the end.

I tried creating a formula that would return the salesperson's name except when it is "Others" in which case I return "ZZZZZ". Then, in the Chart Expert, under the Data tab, I selected the "On change of" field and clicked "Sort". I selected my sorting formula and then ran the report. All was well, except instead of the "Others" label, the label read "ZZZZZ".

(Note, in the about I used quotes to surround "Others" and "ZZZZZ". In actuality these values don't have quotes.)

So, how do I sort without visible changing the bar labels?

TIA