Report by solicitor for all seated orders (unpaid / paid)

I am looking to use an existing report that will include how much revenue our Reservation Associates bring in per week (through unpaid / paid seated orders). I will also need it to reflect per solicitor.

Any thoughts or insight on how this may be attempted would be helpful. Thanks!