Microsoft Office Tutorials and References
In Depth Information
Because you have two attributes on the rows (SalesTerritoryGroup and ProductCategory), the
dialog box contains two columns. Each row in the set contains a filter context that defines
one of the members of the set. All filter contexts together define the set.
It is interesting to see that the first row in the set defines the following:
■ SalesTerritoryGroup = Europe
■ ProductCategory = All
This means that the first element forces a constraint on the SalesTerritoryGroup but leaves
the ProductCategory free to have any value. In fact, if you look carefully at the first row of the
PivotTable, it contains sales made in Europe for all the categories together.
So because there are three values for SalesTerritoryGroup and three values for ProductCategory,
our set contains 13 elements: 9 for the different combinations of a single sales territory and
product category, 3 for the different combinations of sales territories with the unconstrained
category and a final one (the grand total) for the combination of unconstrained territory and
unconstrained category. These elements are exactly the number of rows of the PivotTable. If
you open this dialog box on a complex PivotTable with hundreds (or thousands) of rows, the
number of elements in the set would become very large and hard to manage.
Using this dialog box, you can name the set, provide it with a folder from which to show it,
and update the set definition. For an example, let us edit the set to leave only four elements,
as shown in Figure 8-34.
FIguRE 8-34 Definition of a set made of four elements.