Sunday 22 August 2010

Grouping One Pivot Table Changes Another

Title:
Grouping One Pivot Table Changes Another


Video:


Description:www.contextures.com If you create two pivot tables that are based on the same Excel Table as source data, those pivot tables will share one pivot cache. Then, 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 Excel video tutorial, see the simple steps for creating a second pivot cache, so the two pivot tables can have different date groupings.

Published:
23/Aug/2010

No comments:

Post a Comment