% issue in Pie chart

[#1]

Hi Qv,

How can I show % in pie chart out of 100%.

Please find attached, In my chart I have 1 dimension and 1 expr and expr is :

sum({<Segment={'Group'}>}[Room Revenue])/1000000

Dimension : End user direct/Third party.

Here I'm trying to show the % out of 100%, but it is showing like in the attached image.

So my requirement is, the chart should show

End user accounts - 46%

Third party - 54%.

Thanks,

Ananth

[amit_saini · Accepted solution]

Ananth,

You can click on the "Relative" checkbox.

This option is available under expression tab.

Thanks,

AS

[israrkhan]

try this

check value on data point for the expression

[#4]

Oh my God, How much simple it is.

ThanQ Amit for your quick reply.

[amit_saini]

it is

Cheers!