14 Replies Latest reply: Dec 12, 2013 10:48 AM by Stefan Fischer

# Percent in column

Hi,

in a table chart there are two columns, sum and percent. How can i get percent in column per?

sum    per

961     100%

125       13%

532       55 %

Regards

Stefan

• ###### Re: Percent in column

PFA

sum(cost_eur) / sum(total cost_eur)

Hope this helps.

• ###### Re: Percent in column

see attached...

i actually don´t know what your dimension sort was doing??

• ###### Re: Percent in column

That's fine, it works in my test-file, but in my original file there is something wrong. Please ckeck on attached file, thanks.

• ###### Re: Percent in column

Cannot find attached file...

• ###### Re: Percent in column

Can i send you this file directly?

• ###### Re: Percent in column

No problem, but if you upload it more people will be able to help you. Is is a problem for you to upload it?

• ###### Re: Percent in column

Label: Sum

Exp: Sum(cost_eur)/Sum({1} TOTAL cost_eur)

Go to number -> check Fixed to and Show percent %.

But it is not matching according to your requirement. What is the logic you want to follow here.

• ###### Re: Re: Percent in column

Column A have sum overall columns below. B and C are proprtionatly.

• ###### Re: Percent in column

this?

per = Sum(cost_eur)/MAX(total aggr(sum(cost_eur),structure_name))