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?