Percentages: Show Values As vs. Division Formula

[Manny74]

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?

	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%

 

[Joe4]

What you are talking is an option of a Pivot Table. I beleive that Your data needs to be in a Table in order to do that.

If it is not, if it is just a bunch of listed data rows, I don't think you can do what you want without VBA, in which you would have VBA first do the division, then convert it to hard-coded values. That, however, would not be dynamic. If your data values changed, your percentages would not automatically change unless you ran the VBA code again.

So, why are you against using Pivot Tables or formulas?
Those are the two easiest options here.