Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Percentage (calculated measure) Expand / Collapse
Author
Message
Posted Friday, March 6, 2009 2:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 13, 2012 10:27 PM
Points: 47, Visits: 31
Hi guys,

Am a newbie to BI solutions. We have a scenario where the client is asking for analysis report as shown below:

Top 10 illness by claims paid

Member type: Employee

Diagnosis %

Essential (Primary) Hypertension 14%
Pneumonia, Unspecified 12%
Cholelithiasis 11%

The member type and diagnosis are already available as Dimensions. Claims paid is a measure. I have to arrive the % of claims paid for each diagnosis over the Total claims paid of all the diagnosis.

Since am very new to this analysis reporting, am struggling to find a way to do this %.

I know another way of doing is to modify the underlying MDX query. Since the MDX query is not so user friendly am trying to find out if there are any other possibilities of achieving the above.

Any help is much appreciated.

Cheers,

Hari



Kindest Regards,

Hari

Post #670012
Posted Friday, March 6, 2009 4:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 12, 2011 3:28 AM
Points: 25, Visits: 61
hi
in the textbox go to properties and choose the format tab, next to format code: the is a button with ..., click it and choose percentage, your value might have to be in decimal so that its less than 100%

hope this works
Post #670073
Posted Monday, March 9, 2009 8:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, May 23, 2014 9:02 AM
Points: 216, Visits: 424
Hari, a possibly completely different solution, depending on how you're consuming the data. We use Pivot Tables for a lot of our analysis, and you can just right click on the measure in the pivot table, choose Field Settings, and use % of Column. Voila, you have % of the diagnosis.
If that doesn't work for you, create a new calculated member like this:
([Diagnosis].CurrentMember, [Measures].[Claims Count])/([Diagnosis].CurrentMember.Parent, [Measures].[Claims Count])

Then switch the format to "Percent" just as omlac suggested.

Hope that helps,




Rick Todd
Post #671590
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse