I want to recognize the top n people on a list based on the number of people on the list. I would like to highlight the top n in red based on a number representing n. The number is the result of a percentage based array.
I'm not sure what you meant by your last sentence:
"The number is the result of a percentage based array."
But, if you want those records that are at or above a certain percentile for the group of records, then the following should work. Go to format section->details->color->background color->x+2 and enter:
if {table.amount} >= PthPercentile (80,{table.amount},{table.group}) then crred else crwhite
This would highlight in red all records which exceeded the 80th percentile for the particular group of records.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.