Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table which contains
Dimension: Group,grades(100,90,80,70,60,50)
Expression: Count (Students)
and the pivot look like this
Group | Grades | 100 | 90 | 80 | 70 | 60 | 50 |
A | 80 | 40 | 40 | 40 | - | - | |
B | - | - | 20 | 20 | 20 | 40 | |
C | 2 | - | - | - | - | - | |
D | - | - | - | - | 30 | 20 |
I want to know in each row the percent of student in each grade out of the group, how can i Do that?
Thanks,
Jacob
Count(Students)/count(total <Group> Students)
Count(Students)/count(total <Group> Students)
Gr8 thanks