98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables
Pivot Tables
Resolved · Low Priority · Version 2003
Renate has attended:
Excel Advanced course
Pivot Tables
How do you know which parts of a table to put where in a Pivot Table?
RE: Pivot Tables
Hello Renate
Thank you for your question
This depends on what you want the pivot table to show and how many columns of data you are using in your pivot table. You
can drag any field in the field list to any area, so your choice should be based on what you want to display and how you want to display it. You put values that you want to sum or count in the middle section such as sales value for example. The rest you can experiment with to see the different ways it will be presented.
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
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:The Easiest Way to See a Sum or Average in Excel 2010Did you know the quickest and most simple way of working out the average or sum of a set of numbers? |