PivotTable Named Sets in Excel 2010
User Rating: / 0
Written by Joseph Chirilov   
Tuesday, 06 October 2009 21:51

When working with PivotTables, you often come across scenarios where you want to work with the same set of items from the data over and over again. For example, you might be a regional manager and you want to create a set of reports about the branches in your particular region, but the list of which are “your” branches isn’t in the data source, so you always have to filter to the same eight branches, like so:



Tags: article, excel, set

Pyramid Analytics