Aggregation: The collection of unit parts into a grouping or whole. Totaling Sales by Invoice at the individual level is an aggregate, as is totaling all the Invoices in a listing to get a total for the month, Customer, Manufacturer, etc.
In the screenshot above, we can see that the User-filter is set to the Manufacturer "Havenmade Safety", so both the totals per Payment made to the Agency is shown, as well as the total for that Manufacturer. Further refinement could be done to filter by a specific time range -- year to date or last year, as examples.
Some of the other metrics shown include:
- The average Commission Rate that the manufacturer is paying on each check, and overall.
- The average Split Rate being paid out to the Sales Reps, for those that do commission splits.
- A comparison of the Actual Commission paid to the Agency versus the Anticipated Commission that was records on the Order, for those that track from Order (or PO) to Payment.
- And some metics around how long it take the Manufacturer to ship goods, and then pay the commissions due on those shipments (typically reflecting lead times and payment terms).