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.

See if this helps? [image] Get last n rows from a linked table So I have a parent ->> child one-to-many relationship. I want to get data from the last n rows of the child table for any row in the parent (specifically I want to get the mean of the last n rows). Help? …

Thanks to you both for the extremely helpful guidance.

Average of top ten items by category

Superhuman Ask the Community

Piet_Strydom November 20, 2024, 3:14am 3

See if this helps?

Topic		Replies	Views
Get last n rows from a linked table Ask the Community	17	1152	March 3, 2023
Filter rows in another table and compute average rating in actual table Ask the Community	0	50	July 23, 2024
Filter rows in another table and give average in new table Ask the Community	0	52	July 23, 2024
Top 10 list from table Ask the Community	1	1898	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 Ask the Community	5	891	May 28, 2020

Average of top ten items by category

Related topics