topic Re: Total is not displayed for pivot table in QlikView https://community.qlik.com/t5/QlikView/Total-is-not-displayed-for-pivot-table/m-p/1450007#M434128 <HTML><HEAD></HEAD><BODY><P>PFA</P><P></P><P><STRONG>=Sum(Aggr((((((rangesum(Above(RangeSum(sum(ThirdPartySales),sum(WODistribution),sum(SalesOrder))&nbsp; ,1,RowNo(Total))))</STRONG></P><P><STRONG>/ If(Month_Turns ='Jun', $(vBasePrice), $(vBasePrice)+Sum(InventoryValue_USD))))/2)*-1), BranchPlant, DtDate))</STRONG></P></BODY></HTML> Fri, 10 Nov 2017 12:55:22 GMT Anil_Babu_Samineni 2017-11-10T12:55:22Z Total is not displayed for pivot table https://community.qlik.com/t5/QlikView/Total-is-not-displayed-for-pivot-table/m-p/1450006#M434127 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>PFA.</P><P></P><P>I am using rangesum function but I am not able to display total row.</P><P></P><P>For total row I need to use other formulae.</P><P></P><P>and for rest other.</P><P></P><P>Please suggest.</P></BODY></HTML> Fri, 10 Nov 2017 07:05:35 GMT https://community.qlik.com/t5/QlikView/Total-is-not-displayed-for-pivot-table/m-p/1450006#M434127 kishorj1982 2017-11-10T07:05:35Z Re: Total is not displayed for pivot table https://community.qlik.com/t5/QlikView/Total-is-not-displayed-for-pivot-table/m-p/1450007#M434128 <HTML><HEAD></HEAD><BODY><P>PFA</P><P></P><P><STRONG>=Sum(Aggr((((((rangesum(Above(RangeSum(sum(ThirdPartySales),sum(WODistribution),sum(SalesOrder))&nbsp; ,1,RowNo(Total))))</STRONG></P><P><STRONG>/ If(Month_Turns ='Jun', $(vBasePrice), $(vBasePrice)+Sum(InventoryValue_USD))))/2)*-1), BranchPlant, DtDate))</STRONG></P></BODY></HTML> Fri, 10 Nov 2017 12:55:22 GMT https://community.qlik.com/t5/QlikView/Total-is-not-displayed-for-pivot-table/m-p/1450007#M434128 Anil_Babu_Samineni 2017-11-10T12:55:22Z