Search Contextures Sites
Custom Search

Excel Videos - Pivot Table Groups and Filters

Short Excel videos show to group items in a pivot table, add report filters, apply date filters, and more tips

Group Data in an Excel Pivot Table

Pivot Table Grouping Affects Another Pivot Table

Add Report Filters in an Excel Pivot Table

Use Date Filters in an Excel Pivot Table   

Group Data in an Excel Pivot Table

In an Excel pivot table, you can group dates, number and text fields. For example, group order dates by year and month, or group test scores in bands of 10. You can manually select text items in a pivot table field, and group the selected items. This lets you quickly see subtotals for a specific set of items in your pivot table.

For written instructions for this Excel video tutorial, see the full article: Excel Pivot Tables -- Grouping Data

Pivot Table Grouping Affects Another Pivot Table

When two pivot tables are based on the same Excel Table as source data, by default, those pivot tables will share one pivot cache.If you group the dates in one pivot table, those dates will be automatically grouped in the second pivot table, because of the shared pivot cache.

In this pivot table video tutorial, you can see the simple steps for creating a second pivot cache, so the two pivot tables can create different date groupings. For written instructions, see Pivot Table Grouping

Add Report Filters in an Excel Pivot Table

To focus on specific data in an Excel pivot table, you can add one or more Report Filters.

For more pivot table tutorials, see the list of articles: Excel Pivot Tables

Use Date Filters in an Excel Pivot Table

To focus on specific dates or date ranges in an Excel pivot table, you can add use Date Filters. Click the checkboxes in the list of dates, or enter a specific date range, or choose a dynamic date range..

For more pivot table tutorials, see the list of articles: Excel Pivot Tables

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search

Search Contextures Sites

More Excel Videos

Excel Videos - Index

Data Entry Tips

Names, Macros, Numbers

GetPivotData

Filters, Copy VBA

Pivot Tables

Mouse Shortcuts

Pivot Table Tips

   

 

More Videos

Excel Videos - Index

Data Entry Tips

Names, Macros, Numbers

GetPivotData

Filters, Copy VBA

Pivot Tables

Mouse Shortcuts

Pivot Table Tips

 

 

 

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 29, 2016 2:57 PM