The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
A Way To Have Multiple Tables In One Table?
0
980
0
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?
