How to calculate market share in tableau

Question

I have a ten-country data set. Each nation has more than eight items, and my firm sells three of them in each country: A, B, and C.

So now I'd want to figure out what percentage of the market my items have in each nation.

As an example, if overall sales for 8 items in nation 1 total 100 and sales for products A+B+C total 35, my company's market share in country 1 is 35/100= 35%.

Please assist!

Answer 1

It depends on what you want to do with the data after that; if you just want the number, perform the following:

Make a calculated field in Excel. sum([Sales]) with a fixed [country]: TotalSalesPerCountry (calculates the total sales per country)
Create a calculated variable called CompanySalesPerCountry using the following formula: fixed [country]: sum
(IIF([Product] = 'A' OR [Product] = 'B' OR [Product] = 'C',[Sales],0)) (calculates total amount for each nation when [PRODUCT] = A, B, or C)
AVG([CompanySalesPerCountry]) / AVG([CompanySalesPerCountry]) / AVG([CompanySalesPerCountry]) / AVG([CompanySalesPerCount ([TotalSalesPerCountry])
Change the final field's Properties to 'Percent', then drag [Country] to the rows and [MarketShare] to the columns.

Elevate your data visualization skills with our Tableau Course and unleash the power of insightful analytics.