topic Re: Wrong Total value in pivot table in QlikView https://community.qlik.com/t5/QlikView/Wrong-Total-value-in-pivot-table/m-p/1038771#M921417 <HTML><HEAD></HEAD><BODY><P>Check now</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122983_Capture.PNG" style="height: 257px; width: 620px;" /></P><P></P><P>Exp for Amount</P><P><STRONG>=Sum(Aggr(fabs(sum({&lt;DOCUMENT_TYPE = {'RPT'}&gt;}LOCAL_AMOUNT)), Group, GLAccountName))</STRONG></P><P></P><P>Exp for Overall Total</P><P><STRONG>=Sum(TOTAL Aggr(fabs(sum({&lt;DOCUMENT_TYPE = {'RPT'}&gt;}LOCAL_AMOUNT)), Group, GLAccountName))</STRONG></P></BODY></HTML> Thu, 28 Apr 2016 11:54:41 GMT sunny_talwar 2016-04-28T11:54:41Z Wrong Total value in pivot table https://community.qlik.com/t5/QlikView/Wrong-Total-value-in-pivot-table/m-p/1038770#M921416 <HTML><HEAD></HEAD><BODY><P>Dear Experts , </P><P></P><P>I am Designing Reports in both Reporting tool and Qlikview .&nbsp; i got exact output as per my requirement in reporting tool but in qlikview i am facing issues on displaying partial total and overall total . </P><P></P><P>i want to display partial total in pivot chart , where in expression i used FABS function to convert negative value in to positive . </P><P></P><P>Please suggest how to display correct total value and in overall total expression i am getting group name wise total , i want to display overall total to find out percentage . </P><P></P><P>Please check my attached image and suggest . i want to display output in BI as per attached screen shot&nbsp; (1)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-value-in-pivot-table/m-p/1038770#M921416 2020-11-25T16:16:04Z Re: Wrong Total value in pivot table https://community.qlik.com/t5/QlikView/Wrong-Total-value-in-pivot-table/m-p/1038771#M921417 <HTML><HEAD></HEAD><BODY><P>Check now</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122983_Capture.PNG" style="height: 257px; width: 620px;" /></P><P></P><P>Exp for Amount</P><P><STRONG>=Sum(Aggr(fabs(sum({&lt;DOCUMENT_TYPE = {'RPT'}&gt;}LOCAL_AMOUNT)), Group, GLAccountName))</STRONG></P><P></P><P>Exp for Overall Total</P><P><STRONG>=Sum(TOTAL Aggr(fabs(sum({&lt;DOCUMENT_TYPE = {'RPT'}&gt;}LOCAL_AMOUNT)), Group, GLAccountName))</STRONG></P></BODY></HTML> Thu, 28 Apr 2016 11:54:41 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-value-in-pivot-table/m-p/1038771#M921417 sunny_talwar 2016-04-28T11:54:41Z