Summarise data by a criteria which is in another matrix

Solved2.30K viewsFormulas and FunctionsAverage select Summary
0

In the attached simple model, I have a table named Marks which contains marks by student by course. In another table named Demographics, I have the students names and gender. I want to populate a third table, named Marks by Gender, based on the average marks by gender for each course. How can I do that ?
Many thanks in advance

Answered question

Attachments

Students.model
1

Hi,
In the Marks by Gender matrix, you can use the following formula as a solution;

: = clearerror(average(Marks::)) using Demographics::Gender as Gender
skip Average of Course

Hope this helps.
James

Selected answer as best
0

Great answer, many thanks

Answered question