To produce this information within a report you would need to use the Discount & Commission Analysis (Booking & Production), this can be found within the Reporting Module.

There is a helpsheet (no.HS108) which covers this.  Please click on the following link to view or download helpsheet – HS108 Statistics – Discount & Commisison Analysis.docx or please watch the video below demonstrating this process.