How to calculate market share.

[abc_18]

Hello,

Can some please help  me on how to calculate market share for sales of different companies for different product. I want to calculate market share for company A for X product, Y product, etc. 

I have to show this value in a KPI,  Market share KPI should give value of a selected company in comparison to all other companies, based on product section.

Please suggest.

[jonathandienst]

Something along the lines of:

Sum(Amount) / Sum({<Company>} Amount)

(set expression to override the company selection in the divisor)

[Kashyap_R]

Hi

you can create a KPI with a measure and give filters for company and product

Sum(Sales)/Sum(All Sales)

by filtering they will get to see the share 

Hope this helps

Thanks

[abc_18]

Hi Kashyap,

I was using

sum(sales)
/
sum({<company_name={"*"}>}total sales) expression which gives me 101.5%, but when I used your expression it gives 100% which is correct.

Can you please tell me what is the difference between * and All.

[sunny_talwar]

Is it possible that you have few rows where company_name is null or missing?