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 · Low Priority · Version 2007
Mon 18 Jul 2011, 17:20Delegate Suzi said...
Suzi has attended:
Excel Intermediate course
Excel Advanced course
Pivot Tables
Hi,
I have a huge worklsheet with training data of over 400 people in it which i need to sumarise in the first sheet (for those who can't be bothered to look at all the data)
All i want to select is @Country' and 'Training Completed'. The data in 'Training completed' is either 'Y' or 'N', but the data is not showing up in the table - just the headings.
Driving me mental now!
Tue 19 Jul 2011, 13:29Trainer Simon said...
RE: Pivot Tables
Hi Suzi,
Thank you for your question and welcome to the forum.
Did you add the Training Completed as a column heading?
This would only work if you had a value field like the number of delegates to display under Yes or No.
Try adding the Training Completed field as a second row heading after the Country.
I hope this answers your question.
Regards
Simon
Mon 25 Jul 2011: 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:Convert a column into row quickly in Excel 2010Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa. |
