Good afternoon. I have a table of customer names and then multiple employees by customer. For each employee I have a leadership score. I would like to calculate the average of the top ten company leadership scores. This means I need to determine the leadership score average by employee for each company and then average the top ten of those company level averages. Any suggestions? Do I have to create a separate table of just company summary (average) scores first? Not sure how to do that. If I had that, I suppose I could then simply sort (descending order) and select (slice by) the top 10 and then average that. Iām stuck. Thanks for any guidance you can provide! Can I do it entirely formulaically or do I need to do the interim step of creating the table of averages by company? And how do I do that?
See if this helps?
Hi @Jeb_Dasteel,
You can do it formulaically, sort it descending and take the first 10 or whatever amount you need using the slice formula and a text control.
1 Like
Thanks to you both for the extremely helpful guidance.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.