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
When you answer, click on the "use the advanced editor" link in the right part. It will let you upload a document.
It's uploaded.
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.
Column A have sum overall columns below. B and C are proprtionatly.
That's the right answer. Many thanks for your help.
Stefan