You can drag fields onto any PivotTable area. After you drag a field to the layout diagram, you can customize how it summarizes ...

You can drag fields onto any PivotTable area. After you drag a field to the layout diagram, you can customize how it summarizes the data by double-clicking the field.

When you place numeric fields in the DATA area, the PivotTable subtotals them as a sum. When you place text fields in the DATA area, they are summarized as a count of the rows that contain data.
English
English (United States)
Deutsch (Deutschland)
German (Germany)
Español (España)
Spanish (Spain)
Français (France)
French (France)
italiano
Italian
日本語
Japanese