1 Reply Latest reply on Oct 24, 2018 9:07 PM by Zhouyi Zhang

    Calculating Market Share with 3 different tables

    Spencer Lee


      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.


      Thank you