How to calculate Market Share?

[ameydiwanji]

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

[raghvendrasingh]

Hi Amey,

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

Thanks

[ameydiwanji]

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

[rahulpawarb]

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.

Hope this will be helpful.

Regards!

Rahul

[ameydiwanji]

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

[rahulpawarb]

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