Database Reference
In-Depth Information
you used the
RELATED
function to look up the product category for every product
subcategory row. In these examples, it's easy to think about how these expressions
are applied within the context of each row. When working with measures, we extend
the same concept of filter context to calculate values that aggregate or apply func-
tional logic to the values of all filtered rows. We'll look at some examples to examine
this behavior:
1. With any cell in the
PivotTable
selected, use the
PivotTable Fields
list
to check the
CategoryName
option in the
Product Category
table. This
adds a row to the
PivotTable
for each category. In the
Internet Sales
table measure group/table, check the
Sales Amount
,
Net Profit,
and
Net Margin
measures.
PivotTable queries the model and displays one category per row, and for
each row, the measures are calculated in the context of that row. The first
row is for the
ProductCategory
name:
Accessories
. For every row in
the
Product Category
table with that value, the model navigates through
the relationship to the
Product
table to get a filtered set of rows. It then nav-
Search WWH ::
Custom Search