chat in % but not relative

[#1]

I have above chart region wise. I want it should show % so I used "relative" tick mark. but it takes sum of all data regionwise.

i.e. =5154+2319+1046+733

I want first region should be calculated by 5154 ( divisor should 5154)

for 2nd 2319

so on..

please help me on this.

[Anil_Babu_Samineni]

Narendra, For me question is not clear. Will you able to explain little more

[kaushiknsolanki]

Hi,

What are the dimension you have used?

You will need to use the expression to get the % instead of the Relative Option.

Regards,

Kaushik Solanki

[sunny_talwar]

Assuming you have the following

Dimensions

Dim1

Dim2

Expression

Sum(Measure)

You can try this expression

Sum(Measure)/Sum(TOTAL <Dim1> Measure)