Summing the % values

[k2]

I am having a % field when I aggregates it, am getting the total value of the  percentage say 70%+30%+50% = 150% but not the actual SUM % of the field. Could any one help me out.
Thanks in Advance.

[jdaems]

What kind of rollup have you used for this measure? Check if you have used before rollup or after rollup for the measure?

[k2]

Thanks for the reply, i have sorted out that issue.

[Quantity] / total([Quantity] within set [Month],[Area])

The above thing will display the 100% Total of Quantity sold with respect to Month & Area of sales.

[SanderH]

I need this total function as well to calculate the Marketshare %:

e.g.:
(Quantity / total(Quantity] within set [Competitors])

But the total function it is not available in the functions when I add a calculated measure.

Any idea why?