I have a list with four columns to track different types of commissions (agent commissions and broker commissions):
My current view will only give me a total of each agent and a total of each broker. So it has
- AGENT: John $50; Henry $50
- BROKER: Henry: $100
I need the totals for each person, but sometimes a person will receive Agent commissions and Broker commissions. I need the total of each person (combining the agent and the broker).
So I need it to show
- Henry = $150
- John = $50
How can I acheive this?