How to calculate market share in tableau

0 votes
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!
Mar 17, 2022 in Tableau by Vaani
• 7,070 points
1,598 views

1 answer to this question.

0 votes

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.

answered Mar 28, 2022 by Neha
• 9,060 points

Related Questions In Tableau

0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 9, 2018 in Tableau by ffdfd
• 5,550 points
4,722 views
+1 vote
1 answer

How to calculate the number of hours worked in Tableau?

Try using this LOD expression {fixed user : ...READ MORE

answered Aug 4, 2018 in Tableau by ffdfd
• 5,550 points
1,384 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,746 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,560 points
6,744 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
468 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
426 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
541 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
550 views
0 votes
1 answer

How to share a workbook with client in Tableau who do not have Tableau account or tableau reader

It's possible that there isn't a way ...READ MORE

answered Apr 5, 2022 in Tableau by Neha
• 9,060 points
598 views
0 votes
1 answer

How to upload data to Tableau Server in Python

Then install the tableau-api-lib utility for Python ...READ MORE

answered Mar 4, 2022 in Tableau by Neha
• 9,060 points
2,162 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP