In Numbers, how can I convert the values of a table into percentage values rather than absolute values ?
The percentage are computed per column. The sum of the cells in a column is 100%.
i.e. http://d.pr/NNwn
thanks
numbers
In Numbers, how can I convert the values of a table into percentage values rather than absolute values ?
The percentage are computed per column. The sum of the cells in a column is 100%.
i.e. http://d.pr/NNwn
thanks
Best Answer
If I'm not mistaken you could do that more or less easily:
Say for example column comedy.
The total is 534 (sum).
The sum of 24.71+0.56+0.18+74.53 == 100% (minus rounding, add more decimals for more precision).
So if you add a final ROW with the SUM (below technology for example) you can cause each cell to perform a Cell * 100 / TOTAL_OF_COLUMN and get your %.
What am I missing?