Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables Excel 2007
|
|
|
Bookmark this page|
The UK's most regular 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. |
Pivot Tables Excel 2007
Resolved · High Priority · Version 2007
Reply
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
For upcoming training course dates see: Pricing & availability
RE: Pivot Tables Excel 2007
Hi KevinThank 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
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
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.
|
 |
|
» Forum post: Index function |
What would you use Index & Match for?
