topic Re: Aggregation help in QlikView https://community.qlik.com/t5/QlikView/Aggregation-help/m-p/1560061#M743511 <P>May be try this</P><P>Dimensions</P><PRE>Dept PO ID invoiceID</PRE><P>Expression</P><PRE>Sum(invoiceamt) Sum(invoiceamt) * Sum(%distribution) * 0.01</PRE> Fri, 22 Mar 2019 12:19:48 GMT sunny_talwar 2019-03-22T12:19:48Z Aggregation help https://community.qlik.com/t5/QlikView/Aggregation-help/m-p/1560050#M743510 <P>&nbsp;</P><P>Hi,</P><P>I have below two tables.</P><P>Invoice Table:</P><TABLE><TBODY><TR><TD>Dept</TD><TD>PO ID</TD><TD>invoiceID</TD><TD>invoiceamt</TD></TR><TR><TD>Sales</TD><TD>A1</TD><TD>IN1</TD><TD>5000</TD></TR><TR><TD>Office</TD><TD>A2</TD><TD>IN2</TD><TD>2000</TD></TR><TR><TD>HR</TD><TD>A3</TD><TD>IN3</TD><TD>1500</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>invoice Expense table:</P><TABLE><TBODY><TR><TD>invoiceID</TD><TD>%distribution</TD></TR><TR><TD>IN1</TD><TD>20</TD></TR><TR><TD>IN1</TD><TD>10</TD></TR><TR><TD>IN1</TD><TD>30</TD></TR><TR><TD>IN1</TD><TD>10</TD></TR><TR><TD>IN2</TD><TD>100</TD></TR><TR><TD>IN3</TD><TD>100</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i want to display the below detail</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Dept</TD><TD>PO ID</TD><TD>invoiceID</TD><TD>invoiceamt</TD><TD>invoiceamt modified</TD></TR><TR><TD>Sales</TD><TD>A1</TD><TD>IN1</TD><TD>5000</TD><TD>3500</TD></TR><TR><TD>Office</TD><TD>A2</TD><TD>IN2</TD><TD>2000</TD><TD>2000</TD></TR><TR><TD>HR</TD><TD>A3</TD><TD>IN3</TD><TD>1500</TD><TD>1500</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>where i used (0.01* percentage distribution * invoiceamount) for each entry of the invoice ID in expense table to get the final modified amount.</P><P>how can i get the desired output.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggregation-help/m-p/1560050#M743510 fallenangel6 2020-11-25T16:16:04Z Re: Aggregation help https://community.qlik.com/t5/QlikView/Aggregation-help/m-p/1560061#M743511 <P>May be try this</P><P>Dimensions</P><PRE>Dept PO ID invoiceID</PRE><P>Expression</P><PRE>Sum(invoiceamt) Sum(invoiceamt) * Sum(%distribution) * 0.01</PRE> Fri, 22 Mar 2019 12:19:48 GMT https://community.qlik.com/t5/QlikView/Aggregation-help/m-p/1560061#M743511 sunny_talwar 2019-03-22T12:19:48Z Re: Aggregation help https://community.qlik.com/t5/QlikView/Aggregation-help/m-p/1573657#M743513 <P>Please&nbsp; find the macro file</P> Fri, 26 Apr 2019 08:13:18 GMT https://community.qlik.com/t5/QlikView/Aggregation-help/m-p/1573657#M743513 xavieravinson 2019-04-26T08:13:18Z