pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

resolvedResolved · 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


 

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Server loaded in 0.09 secs.