Changing the data field summary operation


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

Changing the data field summary operation

Most of the data lists you summarize using Pivot Tables contain some sort of financial or personnel data, such as sales or hours worked, which means that you'll usually want to find the sum of the values in the list. You are 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. To change the summary calculation used in the Pivot Table, click any cell in the PivotTable data area. And then, on the PivotTable toolbar, click the Field Settings button.

Then in the Summarize by list, click the operation that you want to use. So if I wanted to change the summary operation to average, I click Average, click OK and Excel now displays the average. For 2008, the monthly average would have been 80.25. For 2009, that number there, and so on. Yo...

Changing the data field summary operation
Video duration: 3m 42s 1h 7m Intermediate

Viewers:

Changing the data field summary operation provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

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