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
Pivot Tables
Resolved · Medium Priority · Version 2003
Tue 7 Jul 2009, 16:21Delegate Christopher said...
Christopher has attended:
Excel Advanced course
Pivot Tables
Where you have multiple values in 1 column on a pivot
i.e. Air Lingus 1000
BMI 50
Total 1050
BA 500
Ethiad 750
Total 1250
etc
How do I express the individual figures as a percentage of the sub total value?
Tue 7 Jul 2009, 17:11Trainer Amanda said...
RE: Pivot Tables
Hello Christopher
Thank you for your question and welcome to the forum.
I think what you're after is using the % of column option for displaying your data items as percentages rather than as values.
To do this, double-click on the grey box that represents the Sum of X (X being your data items/figures); then click the Options button in the PivotTable Field dialogue box that appears on the screen.
Under Show data as, select % of column and click OK.
I hope this helps.
Kind regards
Amanda
Wed 8 Jul 2009, 16:03Delegate Christopher said...
RE: Pivot Tables
Hi Amanda,
It's probably easier that I email a spreadsheet showing what I mean, is this possible?
Wed 8 Jul 2009, 16:06Trainer Amanda said...
RE: Pivot Tables
Hi
Yes, you can if you like and I'll see what I can come up with. My email is amanda@stl-training.co.uk
Kind regards
Amanda
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. |
