topic Re: New Row to pivot table in QlikView https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185382#M882538 <HTML><HEAD></HEAD><BODY><P>If you have a field [Header 1] and you enabled for them the partial sums like above mentioned you will get exactly such a "Total for columns" row for your expressions.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 28 Sep 2016 11:41:13 GMT marcus_sommer 2016-09-28T11:41:13Z New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185375#M882531 <HTML><HEAD></HEAD><BODY><P>Hy there , is there any way to add at the and of the table a row in wich I calculate totals for each column in pivot table?</P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185375#M882531 razvan_brais 2020-11-25T16:16:04Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185376#M882532 <HTML><HEAD></HEAD><BODY><P>This is an inbuilt feature - go to the tab presentation (top left) and there you could enable for each dimension if totals are displayed or not.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 28 Sep 2016 10:54:48 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185376#M882532 marcus_sommer 2016-09-28T10:54:48Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185377#M882533 <HTML><HEAD></HEAD><BODY><P>As Marcus Said, More clear Partial Sum of Dimension which you required</P></BODY></HTML> Wed, 28 Sep 2016 10:56:01 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185377#M882533 Anil_Babu_Samineni 2016-09-28T10:56:01Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185378#M882534 <HTML><HEAD></HEAD><BODY><P>This is not what I`m looking for. I want to have a total for the subtotals as a row in my pivot table.</P></BODY></HTML> Wed, 28 Sep 2016 11:15:43 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185378#M882534 razvan_brais 2016-09-28T11:15:43Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185379#M882535 <HTML><HEAD></HEAD><BODY><P>Are you expecting this</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138970_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 28 Sep 2016 11:20:42 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185379#M882535 Anil_Babu_Samineni 2016-09-28T11:20:42Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185380#M882536 <HTML><HEAD></HEAD><BODY><P>Nope , something like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">Text1</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">Text2</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;"><STRONG>Total for columns</STRONG></TD><TD style="padding: 2px;"><STRONG>50</STRONG></TD><TD style="padding: 2px;"><STRONG>70</STRONG></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 28 Sep 2016 11:37:17 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185380#M882536 razvan_brais 2016-09-28T11:37:17Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185381#M882537 <HTML><HEAD></HEAD><BODY><P>Like this</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138986_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 28 Sep 2016 11:40:44 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185381#M882537 Anil_Babu_Samineni 2016-09-28T11:40:44Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185382#M882538 <HTML><HEAD></HEAD><BODY><P>If you have a field [Header 1] and you enabled for them the partial sums like above mentioned you will get exactly such a "Total for columns" row for your expressions.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 28 Sep 2016 11:41:13 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185382#M882538 marcus_sommer 2016-09-28T11:41:13Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185383#M882539 <HTML><HEAD></HEAD><BODY><P>Marcus , that option I think it`s available only for straight tables . What I have , is a pivot table with a drilldown option. And at the end of the table I would like to sum all values from all rows. </P><P>Anil , that is what I need , but is that possible to achive in pivot table?</P></BODY></HTML> Wed, 28 Sep 2016 11:44:19 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185383#M882539 razvan_brais 2016-09-28T11:44:19Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185384#M882540 <HTML><HEAD></HEAD><BODY><P>No Razva, I did striaght table only. What is the problem to take Straight Table instead of Pivot table. </P></BODY></HTML> Wed, 28 Sep 2016 11:47:31 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185384#M882540 Anil_Babu_Samineni 2016-09-28T11:47:31Z Re: New Row to pivot table https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185385#M882541 <HTML><HEAD></HEAD><BODY><P>Because in straight table i cannot do something like this:<IMG alt="Products.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138985_Products.PNG" style="height: auto; width: auto;" /></P></BODY></HTML> Wed, 28 Sep 2016 11:51:30 GMT https://community.qlik.com/t5/QlikView/New-Row-to-pivot-table/m-p/1185385#M882541 razvan_brais 2016-09-28T11:51:30Z