Calculated formula problem

#1

Quote:

Hi there,
How Can I do this in calculated members ?
Here is my case..

Quote:

Dim Population Calculated members result
12345 100 (100-200)/200
23456 50 (50-200)/200
54678 20 (20-200)/200
09990 10 (10-200)/200
10000 20 (20- 200)/200
--------------------- --------
200

Please help...
Thanks

#2

Are you looking for a calc. measure like this:

Quote:

With Member [Measures].[TotalPopulation] as

'Sum(StrToSet("Axis(1)"), [Measures].[Population])'
Member [Measures].[PctOfTotalPop] as
'[Measures].[Population]/[Measures].[TotalPopulation]',
FORMAT_STRING = 'Percent'

Select {[Measures].[Population],
[Measures].[PctOfTotalPop]} on columns,
{DimZipCode.[12345]

imZipCode.[54678]} on rows
from PopulationCube

Quote:

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Calculated formula problem

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Calculated formula problem - 03-11-2005 , 01:13 PM

Re: Calculated formula problem - 03-11-2005 , 01:57 PM