https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403613#M348174 <P>Hi&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/515693">@Kallis</a>&nbsp;</P> <P>&nbsp;</P> <P>Thanks for updating the data, it makes more sense now. Please see the attached as one way of doing this:</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DavidSkaife_0-1753175582967.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/407801i5791CE40481BEBAC/image-size/medium?v=v2&amp;px=400" role="button" title="DavidSkaife_0-1753175582967.png" alt="DavidSkaife_0-1753175582967.png" /></span></P> <P>&nbsp;</P> <P>Join Excel One to Excel Two using Cost Centre as the join condition, then using the Summerize tool group on Revenue CC and Sum the Values.</P> <P>&nbsp;</P> <P>Workflow attached</P> Tue, 22 Jul 2025 09:14:20 GMT davidskaife 2025-07-22T09:14:20Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403610#M348172 <P><FONT size="1 2 3 4 5 6 7">Hello Friends</FONT></P><P>&nbsp;</P><P><FONT size="1 2 3 4 5 6 7">I have 2 Excel Workbooks.&nbsp;</FONT></P><P>&nbsp;</P><P><FONT size="1 2 3 4 5 6 7">Excel One. Has Cost Centre &amp; Revenue Cost Centre</FONT></P><TABLE><TBODY><TR><TD><FONT size="1 2 3 4 5 6 7">Cost Center</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">Revenue CC</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418ABC</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418ABCDE</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418ABCDEFG</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A2204180000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041800001</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041800010</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041800100</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418001000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A2204180100000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418500</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041856700</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041456666</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A2204150000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A2204160000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><FONT size="1 2 3 4 5 6 7">Excel Two - Has Cost Centre &amp; Value</FONT></P><TABLE><TBODY><TR><TD><FONT size="1 2 3 4 5 6 7">Cost Center</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">Value</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418ABC</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">300</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418ABCDE</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">455</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418ABCDEFG</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">57244</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A2204180000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">114033</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041800001</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">170822</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041800010</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">227611</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041800100</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">284400</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418001000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">341189</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A2204180100000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">397978</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A220418500</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">454767</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041856700</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">511556</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A22041456666</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">568345</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A2204150000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">625134</FONT></TD></TR><TR><TD><FONT size="1 2 3 4 5 6 7">A2204160000</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">681923</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><FONT size="1 2 3 4 5 6 7">The value for each cost centre is in Excel Two.</FONT></P><P>&nbsp;</P><P><FONT size="1 2 3 4 5 6 7">There are multiple Revenue &amp; Cost centres in both the Excels.</FONT></P><P>&nbsp;</P><P>THE COST CENTRE IS UNIQUE</P><P><FONT size="1 2 3 4 5 6 7">The requirement.</FONT></P><P>&nbsp;</P><P><FONT size="1 2 3 4 5 6 7">For every Revenue Cost Centre, I must get the corresponding Cost Centre in Excel One, read all the Cost Centres in Excel Two, get the corresponding Value and total them.</FONT></P><P>&nbsp;</P><P><FONT size="1 2 3 4 5 6 7">Expected Output</FONT></P><P>&nbsp;</P><P><FONT size="1 2 3 4 5 6 7">23C220603 IS THE REVENUE CC in Excel One</FONT></P><P><FONT size="1 2 3 4 5 6 7">4435757 IS THE TOTAL VALUE OF THE REVENUE CC in Excel Two.</FONT></P><P>&nbsp;</P><TABLE><TBODY><TR><TD><FONT size="1 2 3 4 5 6 7">23C220603</FONT></TD><TD><FONT size="1 2 3 4 5 6 7">4435757</FONT></TD></TR></TBODY></TABLE> Tue, 22 Jul 2025 09:06:15 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403610#M348172 Kallis 2025-07-22T09:06:15Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403613#M348174 <P>Hi&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/515693">@Kallis</a>&nbsp;</P> <P>&nbsp;</P> <P>Thanks for updating the data, it makes more sense now. Please see the attached as one way of doing this:</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DavidSkaife_0-1753175582967.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/407801i5791CE40481BEBAC/image-size/medium?v=v2&amp;px=400" role="button" title="DavidSkaife_0-1753175582967.png" alt="DavidSkaife_0-1753175582967.png" /></span></P> <P>&nbsp;</P> <P>Join Excel One to Excel Two using Cost Centre as the join condition, then using the Summerize tool group on Revenue CC and Sum the Values.</P> <P>&nbsp;</P> <P>Workflow attached</P> Tue, 22 Jul 2025 09:14:20 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403613#M348174 davidskaife 2025-07-22T09:14:20Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403649#M348180 <P>Thanks&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/74294">@davidskaife</a>&nbsp;</P><P>It worked like a charm</P> Tue, 22 Jul 2025 12:00:16 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403649#M348180 Kallis 2025-07-22T12:00:16Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403650#M348181 <P>Hi&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/515693">@Kallis</a>&nbsp;</P> <P>&nbsp;</P> <P>Happy to help, would you mind marking my post as the accepted solution as well?</P> Tue, 22 Jul 2025 12:02:39 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403650#M348181 davidskaife 2025-07-22T12:02:39Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403664#M348185 <P>Yes&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/74294">@davidskaife</a>&nbsp;</P><P>I have done that already</P> Tue, 22 Jul 2025 14:10:52 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-total-a-column-in-another-file-based-on-the-data-from-a/m-p/1403664#M348185 Kallis 2025-07-22T14:10:52Z