Percentage (calculated measure)

  • 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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply