topic Re: How to calculate market share. in App Development

How to calculate market share.

abc_18 — Fri, 31 Jan 2020 10:00:44 GMT

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.

Re: How to calculate market share.

jonathandienst — Fri, 31 Jan 2020 10:05:17 GMT

Something along the lines of:

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

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

Re: How to calculate market share.

Kashyap_R — Fri, 31 Jan 2020 10:17:20 GMT

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

Re: How to calculate market share.

abc_18 — Fri, 31 Jan 2020 11:40:23 GMT

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.

Re: How to calculate market share.

sunny_talwar — Fri, 31 Jan 2020 13:17:09 GMT

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