Help on Pivot table

[ranthrave]

Hello Sir/maam I have a pivot table contaning the following data:

Items Count of Yes Count of No
Item 1 25
Item 2 23 2
Item 3 20 5
Grand Total 68 7


My problem is how to make it in percentage? (Like this one)
Items Count of Yes Count of No
Item 1 100 %
Item 2 92 % 8%
Item 3 20 % 20%
Average 91 % 9%

Thank you very much sir

 

[Tom Urtis]

Excel 2010 can do that as a built in feature. What version of Excel are you using. Have you thought about a calculated field if not 2010?

 

[ranthrave]

I try the value setting of % total, row, and column but it messing me up sir..
any idea?

I used MS office excel 2007