calculating pecent

Hi,
Iâ'm trying to find a way to calculate percentage of number of customer for
reporting purposes. (Using reporting services)
In analysis manger I have one dimension called area and one measure called
numberOfCustomer. I want to find how many percent of the customers applies to
each area if the total number of customers is 100%.
Example in a report:
---
USA # of customer
North 5 20 %
South 6 24 %
Europe
Germany 10 40 %
UK 4 16 %
Totally 25 100 %
Same calculation (number of customers and percent) should be done for other
dimensions as well in other reports.
How do I calculate a general percent for number of customer? Is it better to
calculate this via a â'Calculated memberâ' in the cube or should I solve it in
reports?
Any hints? Thanks NilofarWe are just starting with RS. The solution we came up with was to use a
"Calculated Field"
We also came to the conclusion that this may be better handled in the cube
in the future.
"Nilofar" wrote:
> Hi,
> Iâ'm trying to find a way to calculate percentage of number of customer for
> reporting purposes. (Using reporting services)
> In analysis manger I have one dimension called area and one measure called
> numberOfCustomer. I want to find how many percent of the customers applies to
> each area if the total number of customers is 100%.
> Example in a report:
> ---
> USA # of customer
> North 5 20 %
> South 6 24 %
> Europe
> Germany 10 40 %
> UK 4 16 %
> Totally 25 100 %
> Same calculation (number of customers and percent) should be done for other
> dimensions as well in other reports.
> How do I calculate a general percent for number of customer? Is it better to
> calculate this via a â'Calculated memberâ' in the cube or should I solve it in
> reports?
> Any hints? Thanks Nilofar