7 Replies Latest reply: Jan 21, 2014 2:40 PM by Sebastian Pereira

# Custom Report- Market Share Formula

Hi All,

I am trying to calculate Market Share for Competitors across various dimensions. Attached is a sample file with competitors and different market divisions. It is a custom report and fields can be selected like a pivot in excel. However i am not able to get the market share formula right. Please help.

Thanks.

• ###### Re: Custom Report- Market Share Formula

Maybe this is what you need (?):

Sum(Units)/(sum(Total<Competitors> Units))

• ###### Re: Custom Report- Market Share Formula

Thanks Michael. The formula is only working for Competitors field but not for all fields.

• ###### Re: Custom Report- Market Share Formula

I though this is what you wanted...

What about this:

Sum(Units)/(sum(Total Units))

• ###### Re: Custom Report- Market Share Formula

Gaurang: for calculate Market Share, you need to get one total Market (by all competitors) and a parcial Market (for one competitor)

For example, when you have Category and Competitors, what do you want to see?

• ###### Re: Custom Report- Market Share Formula

=Sum(total <Category, Competitors> Units)/(sum(Total <Category >Units))

• ###### Re: Custom Report- Market Share Formula

Thanks Massimo,

This formula only works in case of Category and Competitors. Other Dimension does not show any result.

• ###### Re: Custom Report- Market Share Formula

I see what you need - a dynamic total<>.  You cannot use expression within total<>.

Here is how you can do it.  Create a variable Var, define it this way:

='total<' & GetFieldSelections(_dimension) & '>'

Use it in expression:

=Sum(\$(Var) Units)/(sum(Total <Category >Units))