I have a simple table that lists student’s names, who their teacher is and what musical instrument they’re learning. How can I go about setting up a second sheet to calculate:
- percentage of students by teacher (i.e. what % of students does Jonas teach?)
- percentage of students by instrument (i.e. what % of students are learning piano?)
Ideally this would be able to account for students who take multiple lessons and have multiple teachers. Thanks in advance!