Skip to Content
0
Former Member
Jul 17, 2008 at 02:27 PM

Need a Ranking Function in 2008

20 Views

Does anyone know if there is a ranking function in Crystal 2008? I know there is a "Group sort" option but this doesn't meet my needs.

I'm trying to develop a Sales Report by Territory. The report has a calculated field "% Attainment" for each territory. I need to rank the territories by "% Attainment". The report is sorted in territory number order and cannot be changed. The % Attainment is calculated on Grouping line.

Again the requirement is to keep the report sorted by Territory number.

Exp:

Territory % Attainment Rank

11A00 89% 3

11B00 96% 2

11C00 72% 4

11D00 100% 1

I have used other tools that have a ranking function such as Brio and Excel. I'm surprised I can't find it in Crystal Reports 2008.

Regards,

Mark