4 Replies Latest reply on May 16, 2012 8:50 AM by jon.colby.0

# How do I caluclate a market share number, by dividing one value by another>

Hello,

I need to caluculte the different market share that each account has for the Small Mammal, Fish and Bird category in the UK.

I get a an aggregated total for the market (major multiples) and the value sales for some of the accounts, but not all.  To calculte each accounts share I need to divide the sales in that account by the sales in major multiples.

How can I do this?

Thank you for any help.

• ###### 1. Re: How do I caluclate a market share number, by dividing one value by another>

Hello Jon,

I think there is an option how you could display the desired content without creating a special a table calculation. Just create a basic table that shows 'Geography', 'Product Type' and the 'Value Sales'. Then exclude the 'major multiples' (I understand the 'major multiples' are an aggregation of the different stores), after that you could just apply a 'quick table calculation' to 'Value Sales', in this case 'Percent of Total'.

Maybe this solution works as well for you,

Dennis

• ###### 2. Re: How do I caluclate a market share number, by dividing one value by another>

Hi Dennis,

Thanks for your input.  Unfortunately I do not have all the aggregate parts to major multiples, so I cannot create a share from adding up the parts, and running a quick table calculation.  I need to divide each accout by the major multiples value.

Any Ideas?

Jon

• ###### 3. Re: How do I caluclate a market share number, by dividing one value by another>

Hello Jon,

Since 'major multiples' is an aggregation of the other values, all values associated with it should represent the maximum value in the column 'Value Sales'. So the following formula might work for you:

SUM([Value Sales])/window_Max(sum([Value Sales]))

Place 'Product type' on columns, and 'Geography on rows, change the formatting to percentage, hide 'major multiples', show grand totals, and the result might be the one you were looking for.