98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables Excel 2007
Pivot Tables Excel 2007
Resolved · High Priority · Version 2007
Mon 22 Feb 2010, 08:14Delegate Kevin said...
Kevin has attended:
Excel VBA Intro Intermediate course
Pivot Tables Excel 2007
Once you have created a pivot table that is simply giving you a count - how can you then turn that count into percentages of the totals.
Ie The Pivot will state - for example.
Name Passed Failed Total
Fred 10 5 15
I know want to show the 10 and the 5 as percentages of the total - but without having to add additional columns onto the Pivot
Is there a simpler way - the percentages within Pivot doesn't seem to cut it
Many thanks
Wed 24 Feb 2010, 14:16Trainer Andrew said...
RE: Pivot Tables Excel 2007
Hi Kevin
Thank you for your question. In your count column right click on the label of the column and choose Value Field Settings. From here choose Show values as and change the setting from Normal to Percentage of column.
I hope that helps. Do let us know if you have any further questions.
Kind regards,
Andrew
Wed 24 Feb 2010, 16:21Delegate Kevin said...
RE: Pivot Tables Excel 2007
Hi Andrew thanks for that but it seems to set it to 100% every time?
Am I doing something wrong?
Kevin
Fri 5 Mar 2010, 14:07Trainer Simon said...
RE: Pivot Tables Excel 2007
Hi Kevin,
I am just following up your question.
Have you resolved your Count percentage problem?
Do you have the name field as a row heading and the data as Count of (field)?
If so when you right click over any cell in the data column, choose options and then * of Total.
This should convert the grand column total to 100% and convert the count figures to percentages of that grand total.
If you hide people from the row field the % figures change based on the records counted for those people. So if you have one person showing it will come up as 100% for that person and the grand total.
Regards
Simon
Thu 11 Mar 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Find cells that match a formatIn Excel you may wish to find cells that contain a specific formatting such s colour. |
