We have a rolling bonus for each of our sales representatives and appointment setters. In total there are 10 people eligible for this.
Currently, I have table created for each individual with the data to calculate their rolling bonus.
Columns include:
- Month
- Client Job (linked to another table)
- Contract (rollup)
- Production (rollup)
- Qualified (formula)
- Multiplier
- Bonus (formula)
- Rolling bonus (formula)
- Account ledger (linked to another table)
Is there a way for me to apply all users to this one table instead of having 10 separate tables?
