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 in Tableau by Vaani
• 5,040 points
39 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.
answered Mar 28 by Neha
• 6,260 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 sdfg
• 5,550 points
2,820 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 sdfg
• 5,550 points
601 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,230 points
7,956 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
5,207 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 in Tableau by Vaani
• 5,040 points
48 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

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

Feb 28 in Tableau by Vaani
• 5,040 points
67 views
0 votes
0 answers

Tableau Map view Continent List

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

Feb 28 in Tableau by Vaani
• 5,040 points
38 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 in Tableau by Vaani
• 5,040 points
71 views
0 votes
1 answer
0 votes
1 answer

How to upload data to Tableau Server in Python

https://www.tableautim.com/playlist-video/tableau-tds-and-tdsx-files/csv-to-tdsx Then install the tableau-api-lib utility for Python ...READ MORE

answered Mar 4 in Tableau by Neha
• 6,260 points
61 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP