topic Totals value in pivot table incorrect in App Development https://community.qlik.com/t5/App-Development/Totals-value-in-pivot-table-incorrect/m-p/1277167#M26494 <HTML><HEAD></HEAD><BODY><P>Hi I would like to change the Totals values in a pivot table (top) to resemble those of the normal table (bottom) as shown in the picture. Totals values in the pivot table should be Sum(s) and apart from Sales they aren't. I also don't know how to change the 'Margin as %' into an average value (in the pivot table). <IMG __jive_id="153181" alt="ProfitOverview.jpg" class="jive-image image-1" height="317" src="https://community.qlik.com/legacyfs/online/153181_ProfitOverview.jpg" style="height: 317px; width: 684.808px;" width="685" /></P><P>Also is it possible to change the 'Totals' values colour in the normal table?</P><P></P><P>Thank you in advance for any help.</P><P></P><P>(P.S. the products and values in both the pivot and the normal table are the same.)</P></BODY></HTML> Wed, 15 Feb 2017 12:21:11 GMT 2017-02-15T12:21:11Z Totals value in pivot table incorrect https://community.qlik.com/t5/App-Development/Totals-value-in-pivot-table-incorrect/m-p/1277167#M26494 <HTML><HEAD></HEAD><BODY><P>Hi I would like to change the Totals values in a pivot table (top) to resemble those of the normal table (bottom) as shown in the picture. Totals values in the pivot table should be Sum(s) and apart from Sales they aren't. I also don't know how to change the 'Margin as %' into an average value (in the pivot table). <IMG __jive_id="153181" alt="ProfitOverview.jpg" class="jive-image image-1" height="317" src="https://community.qlik.com/legacyfs/online/153181_ProfitOverview.jpg" style="height: 317px; width: 684.808px;" width="685" /></P><P>Also is it possible to change the 'Totals' values colour in the normal table?</P><P></P><P>Thank you in advance for any help.</P><P></P><P>(P.S. the products and values in both the pivot and the normal table are the same.)</P></BODY></HTML> Wed, 15 Feb 2017 12:21:11 GMT https://community.qlik.com/t5/App-Development/Totals-value-in-pivot-table-incorrect/m-p/1277167#M26494 2017-02-15T12:21:11Z