topic Pivot table vs Microsoft excel in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-vs-Microsoft-excel/m-p/233275#M84812 <HTML><HEAD></HEAD><BODY><P>in your attached file i want that subtotal for boy/girl to appear in 1 chat not on different chat. what can i do?</P></BODY></HTML> Fri, 06 Nov 2009 12:43:07 GMT 2009-11-06T12:43:07Z Pivot table vs Microsoft excel https://community.qlik.com/t5/QlikView/Pivot-table-vs-Microsoft-excel/m-p/233273#M84810 <HTML><HEAD></HEAD><BODY><P>in pivot table, used dimention is <STRONG>main_category</STRONG> which list <STRONG>boys,girls,and men</STRONG></P><P><STRONG>and sub_category</STRONG> which list boy1,boy2,boy3,girl1,girl2,men1,men2,and men3</P><P>On expressinon i have <STRONG>sum(score)</STRONG></P><P>Is the any way that i can calculate the <STRONG>sum(score)</STRONG> of boys/girls in pivot table ?</P><P>Check my attached file for better explanation.</P><P>I will highly appreciate your help!</P><P></P></BODY></HTML> Thu, 05 Nov 2009 19:49:23 GMT https://community.qlik.com/t5/QlikView/Pivot-table-vs-Microsoft-excel/m-p/233273#M84810 2009-11-05T19:49:23Z Pivot table vs Microsoft excel https://community.qlik.com/t5/QlikView/Pivot-table-vs-Microsoft-excel/m-p/233274#M84811 <HTML><HEAD></HEAD><BODY><P>It appears as though you are trying to add a subtotal for the "boy/girl" category and a separate one for the "men" category</P><P>I'd recomend structuring your data to allow sub-totaling by Boys/Girls and by Men/Women. I've attached a qvw with my suggestion</P></BODY></HTML> Thu, 05 Nov 2009 20:25:51 GMT https://community.qlik.com/t5/QlikView/Pivot-table-vs-Microsoft-excel/m-p/233274#M84811 2009-11-05T20:25:51Z Pivot table vs Microsoft excel https://community.qlik.com/t5/QlikView/Pivot-table-vs-Microsoft-excel/m-p/233275#M84812 <HTML><HEAD></HEAD><BODY><P>in your attached file i want that subtotal for boy/girl to appear in 1 chat not on different chat. what can i do?</P></BODY></HTML> Fri, 06 Nov 2009 12:43:07 GMT https://community.qlik.com/t5/QlikView/Pivot-table-vs-Microsoft-excel/m-p/233275#M84812 2009-11-06T12:43:07Z