how to calculate the % in bar chart

[#1]

Hi ...

for ex I have 2000 as rent cost and 200 as non-rent cost.I want to calculate the Rent cost as % of non-rent cost.

How can I put the logic here ?Thanks much.

[t_chetirbok]

Hi!

expression: [rent cost]*100/[non-rent cost]

for your example: 2000*100/200 = 1000 %

[sunny_talwar]

May be add Type of cost as your second dimension and use an expression like this:

Sum(Cost)/Sum(TOTAL <Dimesion1> Cost)