How to Build a Salesperson Commission Report

Commission sheets break when someone sorts the wrong column. Link sales to the person who made them and let the totals take care of themselves.

1. Create a Staff table with a Commission % property.
2. Link every Sale to one salesperson in Staff.
3. On Sales, add a Snapshot rule: "sale total times the salesperson's commission %".
4. On Staff, add a Rollup that sums commission from this month's sales, and a chart view grouped by person.