PercentileRank in Crystal

[DEIO]

I need some assistance determining the percentile rank of data in Crystal.

I can calculate percentile over a group, but I want to know the percentilerank of each data point in the group.
I know I can do this in excel, but have not found a way to do it in Crystal.

PDF from one page of my report is attached. I can calculate the 50th, 65th and 75th percentile of the salary data, but I want to know what percentile rank the comparable salary (in dark blue) is over the set of data.
or
at least show the percentilerank of each salary data point shown.

Alternatively, if I need to include the salary data in dark blue in the data set - I can do that.

PS. I am not a programmer - so VBA/SQL skills are very limited.

 

[tomcat24]

https://stackoverflow.com/questions/770579/how-to-calculate-percentage-with-a-sql-statement

Select Grade, (Count(Grade)* 100 / (Select Count(*) From MyTable)) as Score
From MyTable
Group By Grade

or
as
(
select Grade, count(*)
from MyTable
group by Grade
)
select Grade, GradeCount * 100.0/(select sum(GradeCount) from t)
from t

Search the internet for further examples