Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
76
Views
Topic starter
Hi,
I refer to lesson 7.07 Variables. How will you write the variable if you had more than one subject?
I want the average for Science and average for Maths and other subjects.
And also, if you had another Category. Students in different grades for example.
So I want the average of Science and Maths for Grade6 students and Grade7 students (G8, G9, etc.) for each separate subject.
Thanks in advance 🙂
Regards
Vicky
Posted : 07/12/2020 11:56 pm
Hi Vicky,
You'd need to group the data first, similar to this technique. If you get stuck, please come back with a sample Excel file.
Mynda
Posted : 08/12/2020 1:40 am
