Microsoft Office Tutorials and References
In Depth Information
To better understand the filter context, consider the table shown in Figure 6-1, which is part
of the sample workbook CH06-01-EvaluationContext-demo.xlsx in the companion content.
FIguRE 6-1 Simple Orders table.
When you use this data in a PivotTable, each cell defines a different filter context, which is
used to calculate the value of the measure in that cell. Roughly speaking, the filter context
of a cell is determined by its coordinates in the table.
In Figure 6-2, the cell E5 (which has the value of 64) corresponds to a filter context that includes
■ Color Green (on the row axis)
■ Size Large (on the column axis)
■ Channel Internet (on the slicer)
FIguRE 6-2 Coordinates of cells E5 and G7.
There is no filter on the City attribute. In this example, the filter context corresponds to a
single row of the underlying table. The cell G7, on the other hand, is the sum of all the rows
that have Internet Channel, regardless of their Color, Size, and City value. The sum of these
rows (which are the second half of the table shown in Figure 6-1) has a value of 240. The
relationship between table rows and PivotTable cells is graphically shown in Figure 6-3.