Summarising Data

[Qiro]

I know this one is stupid but I just can't see an elegant way to do it.

I have a table with lots of data, on lots of people, the data itself is not important to my problem. I would like to create a view that summarises it and averages some numbers, and omits others. I know I can do that bit with VCs and a Slice, but here's my real question:

What is the best way to create a view that displays one record for each unique individual in the table, and have each record contain the averaged data from all rows that relate to them?

[WillowMobileSys · Accepted solution]

You will need to add a new Summary table that computes or organizes the person info into a summary row.

The table will contain sheet based or "normal" columns for the non-changing  static data such person ID, any person details, Year, Month, etc.

For all of the computed data that will be changing as rows are entered, use Virtual Columns (VC's) and supply the appropriate expression to calculate the value.  This assumes that multiple people will be entering rows of data that affect the calculations.

[Qiro]

Thank you, I wasn't sure there wasn't a better way than creating another table. Appreciate your help.