topic Aggregation on a Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Aggregation-on-a-Pivot-Table/m-p/315685#M116470 <HTML><HEAD></HEAD><BODY><P>I am trying to aggegate the totals of the standard margin of several Classes in a Category total and cannot seem to find the right formula.&nbsp; I have attached the object, and thank you in advance for any assistance provided.</P></BODY></HTML> Sun, 13 Nov 2011 00:13:02 GMT 2011-11-13T00:13:02Z Aggregation on a Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-on-a-Pivot-Table/m-p/315685#M116470 <HTML><HEAD></HEAD><BODY><P>I am trying to aggegate the totals of the standard margin of several Classes in a Category total and cannot seem to find the right formula.&nbsp; I have attached the object, and thank you in advance for any assistance provided.</P></BODY></HTML> Sun, 13 Nov 2011 00:13:02 GMT https://community.qlik.com/t5/QlikView/Aggregation-on-a-Pivot-Table/m-p/315685#M116470 2011-11-13T00:13:02Z Aggregation on a Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-on-a-Pivot-Table/m-p/315686#M116471 <HTML><HEAD></HEAD><BODY><P>On what basis do you want to group the classes?</P><P></P><P>Regards,</P><P>Kirann</P></BODY></HTML> Sun, 13 Nov 2011 02:17:50 GMT https://community.qlik.com/t5/QlikView/Aggregation-on-a-Pivot-Table/m-p/315686#M116471 2011-11-13T02:17:50Z Aggregation on a Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-on-a-Pivot-Table/m-p/315687#M116472 <HTML><HEAD></HEAD><BODY><P>Try it by changing the expression as below.</P><P></P><P>sum(ExtensionAmt * MarginPct)</P><P></P><P>Hope this is what you were looking for.</P><P></P><P>Regards,</P><P>Sajeevan</P></BODY></HTML> Sun, 13 Nov 2011 08:56:12 GMT https://community.qlik.com/t5/QlikView/Aggregation-on-a-Pivot-Table/m-p/315687#M116472 2011-11-13T08:56:12Z Aggregation on a Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-on-a-Pivot-Table/m-p/315688#M116473 <HTML><HEAD></HEAD><BODY><P> Thank you very much!&nbsp; Amazing what happens by moving a close bracket.</P><P></P><P>Regards.</P></BODY></HTML> Sun, 13 Nov 2011 12:05:16 GMT https://community.qlik.com/t5/QlikView/Aggregation-on-a-Pivot-Table/m-p/315688#M116473 2011-11-13T12:05:16Z