I have two tables, Agent Invoices and Agent percentage of commission.
in the graph i have the agent, year, gross margen average, total invoices, comission % and comission $$$.
I need to calculate the comission depending of gross margen average for every agent.
see included file
Please help me