Output Data Grouping by employee and company

[Kay327]

Hello - I have a list of invoices and I want to display them by employee number. I want the employee number, # of  invoices, and total of invoices on the top line and the invoices grouped by company listed under the employee that works them. Can someone tell me how to achieve this with Alteryx? I have included a sample file of what I want the output to look like.

Thank you.

[Aaron_Harter · Accepted solution]

Hi @Kay327, this is a great use case for the Reporting tools to create batch reports per Employee in your data set:

[Kay327]

Thank you @aaron_harter This is what I was looking for.