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 com…

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.

Average of top ten items by category

Piet_Strydom November 20, 2024, 3:14am 3

See if this helps?

Topic		Replies	Views
Top 10 list from table	1	1809	December 17, 2018
Filter rows in another table and compute average rating in actual table	1	9	October 21, 2024
Filter rows in another table and give average in new table	1	16	October 21, 2024
Get last n rows from a linked table	18	869	June 1, 2023
Averaging the score from multiple rows... only in each group	1	1586	March 15, 2019

Average of top ten items by category

Related topics