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
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
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
