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
Get last n rows from a linked table	18	1070	June 1, 2023
Filter rows in another table and compute average rating in actual table	1	36	October 21, 2024
Filter rows in another table and give average in new table	1	44	October 21, 2024
Top 10 list from table	1	1878	December 17, 2018
How to make a list of rows on a table available for every user and average the results on rows and columns of all users	5	867	May 28, 2020

Average of top ten items by category

Related topics