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