I'm having trouble creating a market share table using 3 different tables.
I'm wondering if the table I want is even possible.
Table 1 - Territory Table - territory is managed by assigning a farm to a US county.
Table 2 - Market Table - lists how many total apples & lemons were sold in each US county.
Table 3 - Lists how many apples or Lemons were sold by Joe, Pam and Dana. (table 1 assigns a farm to each US County, so we know who sold the product)
The final result I would like to create is the table below.