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.
Not 100% sure this works for you or not, but give a try
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...