topic Re: Pivot table - precent of row in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-precent-of-row/m-p/773002#M274255 <HTML><HEAD></HEAD><BODY><P>Gr8 thanks</P></BODY></HTML> Tue, 27 Jan 2015 13:07:57 GMT 2015-01-27T13:07:57Z Pivot table - precent of row https://community.qlik.com/t5/QlikView/Pivot-table-precent-of-row/m-p/773000#M274253 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a pivot table which contains</P><P><STRONG>Dimension</STRONG>: Group,grades(100,90,80,70,60,50) </P><P><STRONG>Expression</STRONG>: Count (Students)</P><P></P><P>and the pivot look like this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 237pt;" width="313"><TBODY><TR style="height: 12.75pt;"><TD align="left" class="xl63" height="17" style="height: 12.75pt; width: 55pt;" width="73">Group</TD><TD align="left" class="xl64" style="width: 32pt;" width="42">Grades</TD><TD align="left" class="xl65" style="border-left: none; width: 25pt;" width="33">100</TD><TD align="left" class="xl65" style="border-left: none; width: 25pt;" width="33">90</TD><TD align="left" class="xl65" style="border-left: none; width: 25pt;" width="33">80</TD><TD align="left" class="xl65" style="border-left: none; width: 25pt;" width="33">70</TD><TD align="left" class="xl65" style="border-left: none; width: 25pt;" width="33">60</TD><TD align="left" class="xl65" style="border-left: none; width: 25pt;" width="33">50</TD></TR><TR style="height: 12.75pt;"><TD align="left" class="xl66" height="17" style="height: 12.75pt; border-top: none;">A</TD><TD class="xl67"> </TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">80</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">40</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">40</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">40</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD></TR><TR style="height: 12.75pt;"><TD align="left" class="xl66" height="17" style="height: 12.75pt; border-top: none;">B</TD><TD class="xl67" style="border-top: none;"> </TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">20</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">40</TD></TR><TR style="height: 12.75pt;"><TD align="left" class="xl66" height="17" style="height: 12.75pt; border-top: none;">C</TD><TD class="xl67" style="border-top: none;"> </TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD></TR><TR style="height: 12.75pt;"><TD align="left" class="xl66" height="17" style="height: 12.75pt; border-top: none;">D</TD><TD class="xl67" style="border-top: none;"> </TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="left" class="xl65" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">20</TD></TR></TBODY></TABLE><P></P><P>I want to know in each row the percent of student in each grade out of the group, how can i Do that?</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76344_pastedImage_3.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thanks,</P><P>Jacob</P></BODY></HTML> Tue, 27 Jan 2015 12:41:58 GMT https://community.qlik.com/t5/QlikView/Pivot-table-precent-of-row/m-p/773000#M274253 2015-01-27T12:41:58Z Re: Pivot table - precent of row https://community.qlik.com/t5/QlikView/Pivot-table-precent-of-row/m-p/773001#M274254 <HTML><HEAD></HEAD><BODY><P>Count(Students)/count(total &lt;Group&gt; Students)</P></BODY></HTML> Tue, 27 Jan 2015 13:00:54 GMT https://community.qlik.com/t5/QlikView/Pivot-table-precent-of-row/m-p/773001#M274254 Gysbert_Wassenaar 2015-01-27T13:00:54Z Re: Pivot table - precent of row https://community.qlik.com/t5/QlikView/Pivot-table-precent-of-row/m-p/773002#M274255 <HTML><HEAD></HEAD><BODY><P>Gr8 thanks</P></BODY></HTML> Tue, 27 Jan 2015 13:07:57 GMT https://community.qlik.com/t5/QlikView/Pivot-table-precent-of-row/m-p/773002#M274255 2015-01-27T13:07:57Z