Pivot table - precent of row

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

Count(Students)/count(total <Group> Students)

[#3]

Gr8 thanks