5 Replies Latest reply: Mar 21, 2017 2:31 AM by Rahul Pawar

# How to calculate Market Share?

Hi All,

Can some please help  me on how to calculate market share for sales of different products for different monthly. Below is the example table. In the attached table i want to calculate market share for product A for Jan month, Feb month, March month, etc. Similarly for B product, C product, D product and so on.

 Brand Jan Feb Mar April A 100 324 94 503 B 200 424 935 585 C 250 636 350 309 D 300 467 578 350 E 400 464 584 330 F 324 464 95 850 G 2 77 853 39 H 42 446 30 593
• ###### Re: How to calculate Market Share?

Hi Amey,

First you need to provide the formula, on what basis you are calculating shares.

Thanks

• ###### Re: How to calculate Market Share?

Hi Raghvendra,

In excel it would be for product 'A' Jan month market share 100/1618 (1618 is total of Jan months sale). For product 'B' it will be 200/1618 and so on. For Feb month for product A 324/3302 (3302 is total of Feb months sale)

Regards,

Amey

• ###### Re: How to calculate Market Share?

Hello Amey,

Please refer below given sample expressions to calculate market share:

// Considering as is data set
//Jan Market Share
Sum(Jan) / Sum(TOTAL Jan)
//Feb Market Share
Sum(Feb) / Sum(TOTAL Feb)
//Mar Market Share
Sum(Mar) / Sum(TOTAL Mar)
//April Market Share
Sum(April) / Sum(TOTAL April)

//After Using CrossTable Load Functionality - which will create a table with Brand, Month & Value fields
Sum(Value) / Sum(TOTAL <Month> Value)

Refer sample application attached herewith.

Regards!

Rahul

• ###### Re: How to calculate Market Share?

Hi Rahul,

Thanks for the reply. I am using below expression in measures

Sum (Sale)/sum(total(Sales))  and using it in line graph

This is giving me wrong market share. Basically i want to show the trend of market share for each product over the period of months

• ###### Re: How to calculate Market Share?

Hello Amey,

Thank you for the prompt response.

Could you please share the application with sample data along with desired results? This will help me to understand the situation and provide your expected response.

Regards!

Rahul