Hi Guru,

We have to build a bar chart to show the count of customers. the table
looks like the follows:

Field Count of customers
1 23
2 20
3 10
4 20
...
we need to show 1-3 field's count of customers as X-axis on the bar
chart;plus, the count of customers belong to "Field number" > 4 need to
be sum up together and then show as ">4" on the X-Axis, In other words,
1,2,3,">4" shows as X-axis.

Do you guys have any solution for this. I have get frustrated from this
and the project deadline is coming. please help if you know how to do.

Thanks,

Eric

I would do the following

1.- Create a calculated column using the summary function RANK, nam
the column RANK and hit OK, you'll have to edit the field again t
change the column association to "Report" so it takes all the line
in your report, also, if necessary, clear any grouping and sorting i
might create leaving only the "rank" grouping

2.- Add a second column, name it Category, with a calculated fiel
with something like " if (RANK < 4) then ( number-to-string
RANK ) ) else ( '>4' )

3.- Create your chart using this column, you should have no problem
email me if you have questions