If your company’s operations are divided into four regions, for example, you might want to display just those results for one of the regions. You can limit the data displayed in a PivotTable by creating a filter.
- [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 mouse pointer over Project,…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Designing a scenario-planning exercise
- Estimating scenario plausibility and outcomes
- Establishing parameter value ranges
- Calculating the standard deviation of a dataset
- Indicating the probability of a scenario value occurring
- Walking through a scenario presentation
- Performing retrospective analysis using a PivotTable
- Changing PivotTable summary operations