Forum Discussion
group by total data not updated
I have a master table that shows which student registered for a course:
| STUDENT ID | COURSE |
| 1234 | xyz |
| 5678 | xyz |
| 1234 | abc |
beneath that I have a table with extra details about students, connected with a 1:many so when a course is selected only the relevant info about the registered students is shown (student_details).
| STUDENT ID | AGE
| GRADE |
| 1234 | 20 | A |
| 5678 | 22 | B |
| 9876 | 21 | B |
Now with my question:
I have created a new table (grades)with agregate data about students grades:
| grade | Total |
| A | 60 |
| B | 80 |
| C | 120 |
grades= GROUPBY(student_details,student_details[grade],"Total",COUNTX(CURRENTGROUP(),student_details[STUDENT ID]))
I've connected my new table "grades" to "student_details" via the grade field. But when I click on a specific course the chart with "grades" data is not updated.
I hope this make sense & thanks in advance for any help.