Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
this?
per = Sum(cost_eur)/MAX(total aggr(sum(cost_eur),structure_name))
PFA
sum(cost_eur) / sum(total cost_eur)
Hope this helps.
see attached...
i actually don´t know what your dimension sort was doing??
Oops, my percentages are not correct
Sorry!
That's fine, it works in my test-file, but in my original file there is something wrong. Please ckeck on attached file, thanks.
Cannot find attached file...
Can i send you this file directly?
No problem, but if you upload it more people will be able to help you. Is is a problem for you to upload it?
this?
per = Sum(cost_eur)/MAX(total aggr(sum(cost_eur),structure_name))
how can i upload?