Hello All,
I am trying to covert numbers to percentage without using a formula....
For example, for Dept Delays, I used =B2/B7 then changed the formatting in column C to percentage
I noticed in another report, that when I used pivot table data, I can right click, select Show Values As, select % of Parent Row Total to have number totals (counts) converted to percentages...
My example below is not pivot table data...just some simple data I put together....But I don't get the option to highlight the data and Show Values As....Is there a way I can convert the totals in column B into percentages, place them in column C, without using a division formula?
I am trying to covert numbers to percentage without using a formula....
For example, for Dept Delays, I used =B2/B7 then changed the formatting in column C to percentage
I noticed in another report, that when I used pivot table data, I can right click, select Show Values As, select % of Parent Row Total to have number totals (counts) converted to percentages...
My example below is not pivot table data...just some simple data I put together....But I don't get the option to highlight the data and Show Values As....Is there a way I can convert the totals in column B into percentages, place them in column C, without using a division formula?
A | B | C | |
1st Quarter | % | ||
2 | Dept Delays | 4 | 50% |
3 | Client Canceled | 1 | 13% |
4 | No Consent | 1 | 13% |
5 | Client left appt | 1 | 13% |
6 | Misc | 1 | 13% |
7 | Total | 8 | 100% |