https://community.qlik.com/t5/QlikView/Pivot-table-show-more-than-one-subtotal-in-only-one-expression/m-p/1806049#M1212102 <P>Dear Expert,</P><P>As illustrated in the subject, I have 3 dimensions (Product Code, Product Desc., Month) and 1 expression Sum(Sales).</P><P>Can I create chart using pivot table that expected result like this?&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dennysetiawan_0-1620372284633.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54492i1FEC1CCDA2B4D272/image-size/medium?v=v2&amp;px=400" role="button" title="dennysetiawan_0-1620372284633.png" alt="dennysetiawan_0-1620372284633.png" /></span></P><P>When I tried it, I found it's difficult to to make 2 subtotals (Total Sales, Avg Sales) with 1 expression.</P><P>Do you have any idea?</P> Fri, 07 May 2021 07:31:51 GMT dennysetiawan 2021-05-07T07:31:51Z https://community.qlik.com/t5/QlikView/Pivot-table-show-more-than-one-subtotal-in-only-one-expression/m-p/1806049#M1212102 <P>Dear Expert,</P><P>As illustrated in the subject, I have 3 dimensions (Product Code, Product Desc., Month) and 1 expression Sum(Sales).</P><P>Can I create chart using pivot table that expected result like this?&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dennysetiawan_0-1620372284633.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54492i1FEC1CCDA2B4D272/image-size/medium?v=v2&amp;px=400" role="button" title="dennysetiawan_0-1620372284633.png" alt="dennysetiawan_0-1620372284633.png" /></span></P><P>When I tried it, I found it's difficult to to make 2 subtotals (Total Sales, Avg Sales) with 1 expression.</P><P>Do you have any idea?</P> Fri, 07 May 2021 07:31:51 GMT https://community.qlik.com/t5/QlikView/Pivot-table-show-more-than-one-subtotal-in-only-one-expression/m-p/1806049#M1212102 dennysetiawan 2021-05-07T07:31:51Z https://community.qlik.com/t5/QlikView/Pivot-table-show-more-than-one-subtotal-in-only-one-expression/m-p/1806314#M1212124 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/2358">@dennysetiawan</a>&nbsp;</P><P>Try like below</P><P><A href="https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-Add-total-and-distribution-field-in-pivot-table/td-p/1762411" target="_blank">https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-Add-total-and-distribution-field-in-pivot-table/td-p/1762411</A></P><P>&nbsp;</P> Sat, 08 May 2021 07:28:24 GMT https://community.qlik.com/t5/QlikView/Pivot-table-show-more-than-one-subtotal-in-only-one-expression/m-p/1806314#M1212124 MayilVahanan 2021-05-08T07:28:24Z