Changing the PivotTable data field summary operation


show more Changing the PivotTable data field summary operation provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Changing the PivotTable data field summary operation

Most of the data that you summarize using PivotTables will have some sort of financial and personal aspect, such as sales or hours worked, which means that you'll usually want to find the sum of the values in the list. You're not limited to adding values together though. You can choose from several summary calculations and also have the ability to change the type of value shown in the data area. For example, you can express individual values as a percentage of the column or row total or compare values to those of the previous year. If you want to change the summary calculation used in a PivotTable, right-click any cell in the PivotTable's data area and that means any cell that contains an individual value.

So, for example, not a grand total or a subtotal and not any of the labels either here in the columns or here for the rows. So instead, right-click any cell in the data area, point to Summarize Values By, and then select the operation that you want to use. In this case, I...

Changing the PivotTable data field summary operation
Video duration: 4m 35s 3h 43m Intermediate

Viewers:

Changing the PivotTable data field summary operation provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...