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.
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)
Retrieving data ...