Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe this is what you need (?):
Sum(Units)/(sum(Total<Competitors> Units))
Thanks Michael. The formula is only working for Competitors field but not for all fields.
I though this is what you wanted...
What about this:
Sum(Units)/(sum(Total Units))
=Sum(total <Category, Competitors> Units)/(sum(Total <Category >Units))
Thanks Massimo,
This formula only works in case of Category and Competitors. Other Dimension does not show any result.
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))
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?