DATA Representing in percentages

[#1]

Hi,

Can any body help me experts.

i have a object like

But i need to display the percentages means John Greg value = 15,173,907. i can be represented in what percentage in 100%.

[Anonymous]

Hi,

let the expression in the bar chart be (value/sum(Total value)) * 100.

HTH.

Ravi N.

[#3]

Hi, Actually in this bar chart i use the expression

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>}  Sales / $(vCurrency))

Then how can i do the percentage representation

[rwunderlich]

Check the "relative" property in the Expression definition.

-Rob

[#5]

Hi Rob Wunderlich,

sorry i can't understand

Can you please explain briefly???

[anbu1984]

Select Relative checkbox in Expressions tab

[CELAMBARASAN · Accepted solution]

You could use relative option or

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>}  Sales) / Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>}TOTAL  Sales)

and check the percentage in number format tab.

[#8]

you can check the Relative checkbox in Expression tab of properties and all the number will be shown in percentage.

[Anonymous]

Hi,

It works either way. U can either select relative tab or u can use an expression that outputs a percentage..

Regards,

Ravi N.

[#10]

Hi Celambarasan Adhimulam.

Thank you So much i got the answer

Thank you all for helping me..