topic Re: Subtotals in pivot tables in QlikView https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365262#M417960 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><IMG alt="1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171261_1.jpg" style="height: 511px; width: 620px;" /></P></BODY></HTML> Tue, 25 Jul 2017 07:35:28 GMT ahaahaaha 2017-07-25T07:35:28Z Subtotals in pivot tables https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365260#M417958 <HTML><HEAD></HEAD><BODY><P>Goodmorning,</P><P></P><P>Im setting up the below pivot table, and need to create subtotals on the first dimension only (channel)</P><P>However I've never done this before, so I don't know where to do this.</P><P></P><P>So how do I create subtotals per channel?</P><P></P><P>gr</P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171256_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 25 Jul 2017 07:27:25 GMT https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365260#M417958 tim_leijen 2017-07-25T07:27:25Z Re: Subtotals in pivot tables https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365261#M417959 <HTML><HEAD></HEAD><BODY><P>Looks like this is Pivot Table only, Can you check in presentation tab as "<STRONG>Partial Sum</STRONG>" for first dimension and then use</P></BODY></HTML> Tue, 25 Jul 2017 07:30:15 GMT https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365261#M417959 Anil_Babu_Samineni 2017-07-25T07:30:15Z Re: Subtotals in pivot tables https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365262#M417960 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><IMG alt="1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171261_1.jpg" style="height: 511px; width: 620px;" /></P></BODY></HTML> Tue, 25 Jul 2017 07:35:28 GMT https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365262#M417960 ahaahaaha 2017-07-25T07:35:28Z Re: Subtotals in pivot tables https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365263#M417961 <HTML><HEAD></HEAD><BODY><P>Hi Tim,</P><P></P><P>Please provide sample data.</P><P></P><P>Thanks,</P><P>Arvind Patil</P></BODY></HTML> Tue, 25 Jul 2017 07:44:46 GMT https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365263#M417961 arvind_patil 2017-07-25T07:44:46Z Re: Subtotals in pivot tables https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365264#M417962 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;"><STRONG>Presentation ==&gt; Partial Sum</STRONG></SPAN><SPAN style="font-size: 13.3333px;"> should be Account Group</SPAN></P><P><IMG __jive_id="171265" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171265_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 25 Jul 2017 07:53:10 GMT https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365264#M417962 Nagaraju_KCS 2017-07-25T07:53:10Z Re: Subtotals in pivot tables https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365265#M417963 <HTML><HEAD></HEAD><BODY><P>Hi Andrey! Thanks, didn't know it was this simple, I was actually thinking I had to add a formula in the dimension! It worked!</P></BODY></HTML> Tue, 25 Jul 2017 08:01:36 GMT https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365265#M417963 tim_leijen 2017-07-25T08:01:36Z Re: Subtotals in pivot tables https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365266#M417964 <HTML><HEAD></HEAD><BODY><P>Was glad to help you.</P></BODY></HTML> Tue, 25 Jul 2017 11:32:43 GMT https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-tables/m-p/1365266#M417964 ahaahaaha 2017-07-25T11:32:43Z