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.