Pivot table help!

[Amber_w]

I have a pivot that is fine. There is a colum that has a total COUNT which I need BUT I also need a % of the total too... So I took the same column from the pivot table field and set in there but it doesnt work. The pivot table is huge so I cant calculate it manually... is there a way to fix this?

Thanks!

Amber-

 

[Richard Schollar]

Hi Amber

Please explain what you meant by "it doesn't work" - how doesn't it work?

 

[Amber_w]

well I the formatting is not the way I want it... I would like it to be a column and it makes it a row.. I cant compare the values..

 

[Richard Schollar]

Right-Click on the Pivot Table button called 'data' and go down to Group and then select "Move to column"

 

[Amber_w]

Thank you!