|
|
Search
Contextures Sites
|
||
|
|
|
|||
Contextures Inc., Copyright ©2012
All rights reserved.
Search Contextures Sites
Excel Tutorial Videos 11
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 TableGroup 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
Contextures Inc., Copyright ©2012
All rights reserved.
Last updated: November 4, 2010 10:43 AM
