topic Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/485700#M181466 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have Pivot table, i want to display below format,&nbsp; but don't want use <STRONG>partial sums</STRONG></P><P></P><TABLE height="118" style="width: 349px; height: 120px;"><TBODY><TR><TD><STRONG>Category</STRONG></TD><TD><STRONG>Product </STRONG></TD><TD><STRONG>sum(Qty)</STRONG></TD></TR><TR><TD>Nokia</TD><TD><P>Nokia1</P></TD><TD>1</TD></TR><TR><TD><BR /></TD><TD>Nokia2</TD><TD>3</TD></TR><TR><TD><BR /></TD><TD>Nokia3</TD><TD>4</TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><STRONG>8</STRONG></TD></TR><TR><TD>Samsung</TD><TD>Sam1</TD><TD>2</TD></TR><TR><TD><BR /></TD><TD>Sam2</TD><TD>5</TD></TR><TR><TD><BR /></TD><TD>Sam3</TD><TD>10</TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><STRONG>17</STRONG></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Thanks .............</P></BODY></HTML> Mon, 12 Aug 2013 18:00:41 GMT Nagaraju_KCS 2013-08-12T18:00:41Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/485700#M181466 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have Pivot table, i want to display below format,&nbsp; but don't want use <STRONG>partial sums</STRONG></P><P></P><TABLE height="118" style="width: 349px; height: 120px;"><TBODY><TR><TD><STRONG>Category</STRONG></TD><TD><STRONG>Product </STRONG></TD><TD><STRONG>sum(Qty)</STRONG></TD></TR><TR><TD>Nokia</TD><TD><P>Nokia1</P></TD><TD>1</TD></TR><TR><TD><BR /></TD><TD>Nokia2</TD><TD>3</TD></TR><TR><TD><BR /></TD><TD>Nokia3</TD><TD>4</TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><STRONG>8</STRONG></TD></TR><TR><TD>Samsung</TD><TD>Sam1</TD><TD>2</TD></TR><TR><TD><BR /></TD><TD>Sam2</TD><TD>5</TD></TR><TR><TD><BR /></TD><TD>Sam3</TD><TD>10</TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><STRONG>17</STRONG></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Thanks .............</P></BODY></HTML> Mon, 12 Aug 2013 18:00:41 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/485700#M181466 Nagaraju_KCS 2013-08-12T18:00:41Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/485701#M181467 <HTML><HEAD></HEAD><BODY><P>You can try using the Indent option on the Style tab. I don't think it's possible to align the cell values of the first dimension at the top of the cell instead of the bottom though. That seems to be possible only if you also choose show the subtotals on top (on the Presentation tab). See attached example. </P></BODY></HTML> Mon, 12 Aug 2013 18:05:55 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/485701#M181467 Gysbert_Wassenaar 2013-08-12T18:05:55Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/485702#M181468 <HTML><HEAD></HEAD><BODY><P>If you don't want to use partial sums, just have to uncheck the option of show partial sums for the 'Category' dimension. It's on the presentation tab.</P></BODY></HTML> Wed, 14 Aug 2013 13:24:12 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/485702#M181468 2013-08-14T13:24:12Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/485703#M181469 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 14 Aug 2013 13:28:27 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/485703#M181469 MayilVahanan 2013-08-14T13:28:27Z