Microsoft Office Tutorials and References
In Depth Information
Note An item grayed in a slicer indicates that the selection of that member does not have any
effect on the result of the PivotTable because values for that item are already filtered out by
selections of other attributes, or in other words, by the filter context.
If you change the selection of the Continent Slicer by choosing Europe, the filter context
activates three rows in the Cities table. Only rows corresponding to these cities are active
in the Orders table, as you can see in Figure 6-24.
FIguRE 6-24 Filter context defined by the selection of Europe.
The filter context defined for the Orders table is further reduced when single cells of the
PivotTable are evaluated. For example, cell E5 includes only the row <Torino, Store, Green,
Large> because it is the only one that satisfies the user filter <Europe, Green, Large> that
results from user selection. This type of user filter is <Europe, Red> for cell G6 and includes
two rows from the Orders table. We used the term user filter because it represents the will
of the user, regardless of the number of internal operations that are necessary to define the
exact requirements of the filter for the table containing the values to extract.
At this point, you can still add filters to the evaluation context by using FILTER as a parameter
of an aggregation function like SUMX, in the same way you have seen is valid for a single
table. However, you need to use a different approach if you need to remove filters from
the filter context—for example, if you want to calculate a ratio between the amount for a
color and the corresponding amount for an item regardless of the color.