Top Contributors

[ReliabEng]

Hi,



I'm trying to get a report from a database. This is all good. The whole database and reports are set up but I'm struggling to get the top contributors.

I want to have a report that only displays set number of top contributors based on one column.

Additonally I wanted to get the top contributors to be highlighted. I was attempting to do this using condition formatting but I was unable to get it to work correctly.

Could anyone please give me some advice on how to achieve these two effects or point me to a source where I can find this? I was unable to find anything specific on Google. I've spent a fair bit of time on this yet and other projects are pressing.

Thanks

[pbaldy]

Try the TOP predicate in you query:

SELECT TOP 10...
FROM
ORDER BY YourField