Grouping fields


show more Grouping fields 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 ...

Grouping fields

When you summarize your data using a Pivot Table, Excel organizes the data based on the order of the fields and the column area and the row area. As an example, in this Pivot Table, which has a column of data arranged by Company, Year, and Month, you can hide the details for each year or for each company. For example, if I wanted to hide all of the values for 2008 for FirmA and just express it as a subtotal, I can double click that header cell and get rid of the values. They are still there. They are just not displayed. If I double-click the same cell, the values come back. In exactly in the same way, I can double-click the FirmA cell and Excel collapses all of the FirmA values and just gives me a subtotal for FirmA for Year 2008 and 2009.

Double-clicking brings them back. In this Pivot Table, the Months are at the lowest level, so you can't hide them individually. As the Pivot Table stands now, you can only hide the monthly results by hiding every month for the entire year. If you do w...

Grouping fields
Video duration: 2m 48s 1h 7m Intermediate

Viewers:

Grouping fields 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 ...