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 want to show or hide groups of months, you can do so by creating a group.…

Resume Transcript Auto-Scroll

Author

Released

9/22/2009

In Excel 2008 for Mac: Pivot Tables for Data Analysis, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, demonstrating how to use this powerful tool to discover valuable business intelligence. Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and prepare a Pivot Table report by applying formats and rules. Exercise files accompany this course.