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