Custom Report- Market Share Formula

[#1]

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.

[Anonymous]

Maybe this is what you need (?):

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

[#3]

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

[Anonymous]

I though this is what you wanted...

What about this:

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

[maxgro]

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

[#6]

Thanks Massimo,

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

[Anonymous]

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))

[sebastiandperei]

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?