Pivot help on getting average and top 5

[bavarunbansal]

Hi All,
I hope you all are doing well. I am trying to work on a requirement in Pivot and stuck at a point where I would need help from you folks.

In the attached sheet, what I need help is with the following -

1. Get average of rating for each trade.
2. Pick top 5 companies under each trade with highest rating.

Could you folks help me with this? Thank you all in advance and appreciate your help and time.

Best,
Varun

[XLent]

not entirely sure I follow but, if you right click on company_name you can apply a Value Filter (Top 10...) of Top 5 relative to Average rating

the above would only list companies whose Average rating is in the Top 5 for the given Trade.