For example, assume you have a list of voting results that includes voter age, and you want to summarize the results by age group: When you add fields to a pivot table, the pivot table will display the name that appears in the source data.Value field names will appear with "Sum of " or "Count of" when they are added to a pivot table.

updating pivot tables in excel-31updating pivot tables in excel-67updating pivot tables in excel-42

For example, suppose you have a list of employees and want to get a count by department?

To get a breakdown by department, follow these steps: In many pivot tables, you'll want to show a percentage rather than a count.

Although it's a lot of fun dragging fields around a pivot table, and watching Excel churn out yet another unusual representation of the data, you can find yourself going down a lot of unproductive rabbit holes very easily. Before you start building, jot down what you are trying to measure or understand, and sketch out a few simple reports on a notepad.

These simple notes will help guide you through the huge number of choices you have at your disposal.

To do this, simply add any text field as a Value field.

You'll see a very small pivot table that displays the total record count, that is, the total number of rows in your data.To use a Table for your pivot table: By default, a Pivot Table will count any text field.This can be a really handy feature in a lot of general business situations.For example, suppose you have sales data and you want to see a list of every product that was sold.To create a product list: See: How to make a self-contained pivot table Although pivot tables automatically group data in many ways, you can also group items manually into your own custom groups.Group 1 and Group 2 don't appear in the data, they are your own custom groups.