Summarise data by a criteria which is in another matrix

Solved2.83K viewsFormulas and FunctionsAverage select Summary

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
You are viewing 1 out of 2 answers, click here to view all answers.