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
Fri 30 Oct 2009, 15:53Delegate Jo said...
Jo has attended:
Excel Advanced course
Pivot tables
How do you decide which variables you drop into each field?
Sun 1 Nov 2009, 18:57Trainer Simon said...
RE: Pivot tables
Hi Jo,
Thank you for your question.
There is no right and wrong answer to that question. The fields you use depend on how you want to analyse the data.
You decide on your Page fields, row and column headings and data field.
I hope this answers your question.
Regards
Simon
Mon 9 Nov 2009: 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:Outlining - ungrouping rows or columnsHighlight want you want to ungroup and press ALT + SHIFT + right cursor arrow |
