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

    Calculating Market Share with 3 different tables

    Spencer Lee

      Hello,

      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