Convert Multiple Measures into categorized Dimension

[Sri251]

Hi Everyone,

I need your inputs:

I am in a situation to convert 4 measures into dimension like a category

For example: My measures are Male Patients Count, Female Patients Count, Asian Male Patients Count, Asian Female Patients count.

Basically I need to create a pie chart based on the above mentioned measures and i need to place all the above mentioned measures into a single dimension like a category and i need to use this category as a dimension in the pie chart, so when i create a pie chart it will give their individual distribution.

Appreciate if someone can advice me the best approach!

TIA,
Sri

[Sri251 · Accepted solution]

I got the solution: I have created a calculated dimension with the help of value list for the above mentioned measures and also used the pick match function in the measure section to calculate the % share in the pie chart.

Hope it will be helpful for someone!