Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
This might be a simple question, but I can't seem to wrap my head around it. I have a table which can be simplified to the one below:
Class | Group | Score |
A | 1 | 10 |
A | 2 | 20 |
A | 3 | 50 |
B | 4 | 80 |
B | 5 | 85 |
B | 6 | 40 |
I want the average score for my selections which I can get by using a simple Avg(Score). When I select Class = A and Group = 2 then my Avg(Score) will give me 20. How can I get the average for the scores in my selected Class (A), but for the Groups which are not in my Group selection (1 and 3). In other words, when I select the class and group in green in the table below, I want to get the average of the blue values (=(10+50)/2=30).
Class | Group | Score |
A | 1 | 10 |
A | 2 | 20 |
A | 3 | 50 |
B | 4 | 80 |
B | 5 | 85 |
B | 6 | 40 |
Please let me know if anything is unclear.
Regards,
Mauritz
hi
this expressions will do the trick
Avg({<Group=e(Group)>}Score)
what it does , it disregards the selection in the group field and instead use the excluded values from the field
hi
this expressions will do the trick
Avg({<Group=e(Group)>}Score)
what it does , it disregards the selection in the group field and instead use the excluded values from the field