Market share growth company wise

[abc_18]

Hi,

I am using below expression to calculate the company wise market share, but the below expression gives me market share for one company, even if I wont select any company from filter.

=Sum(sales)
/
Aggr(Sum({<company_name=>} sales),FYear)

[Vegar]

Try this:

=Sum(sales)
/
Sum(total <FYear> sales)

[abc_18]

Hi Vegar,

Thank you.

I tried to implement as suggested by you, its' working fine if I won't select any company then it's giving correct trend for all companies.

only issue I am facing now is in X axis it's giving 0.00% values  if I select any particular company

.

Please suggest, if any changes is required.

[Vegar · Accepted solution]

You are right,  it calculates the share of the companies in your selection. If you want to force all companies into your denominator you'll have to add the company_name modifier you had in your original aggr function.

=Sum(sales)
/
Sum(total <FYear> {< company_name >} sales)

[johnsmith001]

Hi,

To calculate market share by company and account for filtering, consider modifying your expression:

Market Share=Sum(sales)Sum(Total <company_name> sales)Market Share=Sum(Total <company_name> sales)Sum(sales)​

This ensures that the market share is computed based on the selected company while considering the overall sales for all companies. For information on embedded systems companies in India, feel free to ask!