Calculating participation (Market Share)

[#1]

Hi there.

Would somone help me on how I can calculate the market share or participation of each dimension row for a table with one dimension and one sum(e.g.sold value) for the expression.

[richard_pearce6]

Hi,

Have you tried using the expression: sum( Sold_Value) / Sum (Total Sold_Value) ?

If you're just interested in the frequency of the Dimension I tend to add a new row in the table import script:

1 as RowCount

The expressions now becomes: sum( RowCount) / Sum (Total RowCount)

Richard