Percent in column

[Anonymous]

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

[salto]

PFA

sum(cost_eur) / sum(total cost_eur)

Hope this helps.

[michael_maeuser]

see attached...

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

[salto]

Oops, my percentages  are not correct

Sorry!

[Anonymous]

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

[salto]

Cannot find attached file...

[Anonymous]

Can i send you this file directly?

[salto]

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

[#9 · Accepted solution]

this?

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

[Anonymous]

how can i upload?