Market Share calculation

[danialier]

Hello,

I want a List Box to show the market share of different companies based on the country I select in a Text Box. The formula I use is the following one but it does not work... Please help.

  =num(sum({<Company=>}units))/num(sum(units))

thks,dani

[MK_QSL]

SUM({<Company = >}units)/sum({1}units)

or

NUM(SUM({<Company = >}units)/sum({1}units),'#,##0.00%')

[hic]

Not sure what you really want... A list box does normally not show a calculation and you cannot make a selection in a text box.

But - If you show the market shares in a chart where you have Companies as dimension, you can calculate the market shares through

  Sum(units) / Sum(total units)

HIC

[maxgro]

perhaps you want the market share in a chart

and you select the country in a listbox?

[jonathandienst · Accepted solution]

Hi

I assume that there is an association between country and company? I would put Country in a list box and show the market share in a pivot or straight table.

Is the market share by country, or for all countries?

Your expression will be something like (share by country):

     =Sum(units) / Sum(Total Units)

or (share for all countries)

     =Sum(units) / Sum({<Country=>}Total Units)

The num() function does nothing in these expressions, it just changes the display format of the number.

HTH

Jonathan

[bgerchikov]

Hi Dani,

Try this one:

SUM(units)/SUM(TOTAL <Country> units)

Hope it will help

[its_anandrjs]

Hi,

Create a chart based on the Market share and display that one and use list box for country and other selection would be better idea.

Use expression like

=num(sum(units)) / num(sum(Total units))

Thanks & Regards