Pivot table - Using other components

Working with the PivotTable Fields list

In the Field Name area at the top,, select the check box for any field you want to add to your PivotTable. By default, non-numeric fields are added to the Row area, data and time fields are added to the Column area, and numeric fields are added to the values area. You can also manually drag-and -drop any available item into an of the PivotTable fields, or if you no longer want an item in your PivotTable, simply drag it out of the Fields list or uncheck it. Being able to rearrange Field items in one of the PivotTable features that makes it so easy to quickly change it appearance.

PivotTable Fields list                                                  Corresponding files in a PivotTable

 

PivotTable Values

• Summarize Values By

By default, PivotTable fields that are placed in the Values area will be displayed as a SUM. If Excel interprets your data as text, it will be displayed as a COUNT. This is why it's so important to make sure you don't mix data types for value fileds. You can change the default calculation by first clicking on the arrow to the right of the field name, then select the Value Field Settings option.

Next, change the calculation in the Summarize Values By selection. Note that when you change the calculation method, Excel will automatically append it in the Custom Name section. like " Sum of FieldName", but you can change it. If you click the Number Format button, you can change the number format for the entire field.