Need to group invoices with Invoice total and # of items per invoice

[ppatane]

I have tried the Union and Append fields joins but the results weren't even close (I ended up with 126 rows for each invoice...there are 126 rows in the original data.)  I have attached the starting data file, and the desired output file.

I want to get from the first screenshot to the second

[cjaneczko · Accepted solution]

Use a summarize tool that is grouped by invoice number. Then use a join tool to join the summarized data back to the main set. 

[ppatane]

Thanks cjaneczko! I see my error, I was renaming the Grouped by Invoice numbers and wasn't seeing where to join