Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I'm running into an issue that I'm sure is pretty common but I haven't been able to resolve on my own yet. We have a very basic app that needs to be built that shows sales rep performance vs. quota for specific targeted accounts. The files consist of the Quota (Rep, Month, Type, Quota), Sales (Customer, Month, Type, Amount), and Customer (Customer, Customer Contact, State, Rep). At the end of the day, we need to roll up the sales by type and compare it to the quota by type for each rep. Mockups of each table are attached and examples are below.
The issue that I see is that quota is not set at the customer level, the customer data doesn't contain a month or type field, and the sales data doesn't contain the rep. So I'm left with a circular association (below) that still doesn't return what I'm looking for. Any feedback on how to approach this is greatly appreciated. Thanks!
Quota:
Rep | Month | Type | Quota |
Jim | July | Commercial | 100000 |
Jim | August | Commercial | 110000 |
Jim | September | Commercial | 120000 |
Jim | July | Residential | 50000 |
Jim | August | Residential | 60000 |
Jim | September | Residential | 70000 |
Jim | July | Industrial | 55000 |
Jim | August | Industrial | 55000 |
Jim | September | Industrial | 55000 |
Sales:
Customer | Sale Month | Type | Amount |
185188 | July | Commercial | 10900 |
107227 | July | Commercial | 20888 |
157811 | July | Commercial | 2282 |
148966 | July | Residential | 4913 |
118633 | July | Industrial | 16446 |
197725 | July | Industrial | 2398 |
114268 | July | Industrial | 7265 |
133108 | July | Industrial | 23461 |
191580 | July | Residential | 11848 |
173991 | July | Commercial | 20506 |
Customer:
Customer | Customer Contact | State | Rep |
185188 | Isis Hellman | ME | Kawal |
107227 | Alesia Mains | LA | Kawal |
157811 | Lindsy Lew | NV | Denise |
148966 | Racquel Gregor | NM | Jim |
118633 | Harriet Neathery | VA | Denise |
197725 | Rosita Ransome | NH | Kawal |
114268 | Deedra Candler | KS | Kawal |
133108 | Linwood Coursey | HI | Jim |
191580 | Hsiu Mento | NM | Kawal |
173991 | Gaynell Henkel | DE | Jim |