From the course: Excel: Scenario Planning and Analysis

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Filter PivotTable data

Filter PivotTable data

From the course: Excel: Scenario Planning and Analysis

Start my 1-month free trial

Filter PivotTable data

“

- [Instructor] Pivot tables can summarize huge data collections, but many times, you'll want to limit the data displayed in a given category. For example, if you are overseeing four projects as part of a program, you might want to only display data for a specific project. You can limit the data displayed in a pivot table by creating a filter. In this movie, I will show you how to create filters. My sample file is Project Analysis_04_04. It's an Excel workbook that you can find in the Chapter04 folder of your Exercise Files collection. The pivot table in this workbook summarizes actual labor data for a series of four projects. The current layout of the pivot table displays the data by year, for 2016 to 2017. Let's say that I want to filter my pivot table, so I only see the data for the MT22841 project. There are a number of ways that I can create that filter. If the PivotTable Fields pane is displayed, I can go over to the field list, and I'll be filtering by project, so I'll hover my…

Contents