topic Re: SubTotal issue in PivotTable in QlikView https://community.qlik.com/t5/QlikView/SubTotal-issue-in-PivotTable/m-p/112526#M762511 <HTML><HEAD></HEAD><BODY><P>Thanks Prashant.....</P><P>I Thought if I use "Sum" values may get wrong...<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P>It's working thanks for help!!</P></BODY></HTML> Tue, 07 Aug 2018 11:03:38 GMT Bala_s 2018-08-07T11:03:38Z SubTotal issue in PivotTable https://community.qlik.com/t5/QlikView/SubTotal-issue-in-PivotTable/m-p/112524#M762509 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have issue in SubTotal in pivot Table, I made check mark for show PartialSum, but still no luck.</P><P>I need to show Sales month on month for Countries and I need to provide Region wise SubTotal.</P><P>My expression is: only(Sales).</P><P></P><P>Request help here at the earliest.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/SubTotal-issue-in-PivotTable/m-p/112524#M762509 Bala_s 2020-11-25T16:16:04Z Re: SubTotal issue in PivotTable https://community.qlik.com/t5/QlikView/SubTotal-issue-in-PivotTable/m-p/112525#M762510 <HTML><HEAD></HEAD><BODY><P>Instead of only() use sum()</P><P></P><P>sum(Sales)</P><P></P><P>Regards,</P></BODY></HTML> Tue, 07 Aug 2018 10:56:50 GMT https://community.qlik.com/t5/QlikView/SubTotal-issue-in-PivotTable/m-p/112525#M762510 PrashantSangle 2018-08-07T10:56:50Z Re: SubTotal issue in PivotTable https://community.qlik.com/t5/QlikView/SubTotal-issue-in-PivotTable/m-p/112526#M762511 <HTML><HEAD></HEAD><BODY><P>Thanks Prashant.....</P><P>I Thought if I use "Sum" values may get wrong...<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P>It's working thanks for help!!</P></BODY></HTML> Tue, 07 Aug 2018 11:03:38 GMT https://community.qlik.com/t5/QlikView/SubTotal-issue-in-PivotTable/m-p/112526#M762511 Bala_s 2018-08-07T11:03:38Z