Summarise data by a criteria which is in another matrix
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
vpluchet Answered question October 29, 2018
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.
vpluchet Selected answer as best October 29, 2018