Microsoft Office Tutorials and References
In Depth Information
FIguRE 9-10 The first top-10 products sorted by SalesAmount with the ProductRank measure shown in the
You can see in Figure 9-11 that the same ProductRank works dynamically over the other
selections that are active in the PivotTable. In this case, there are two models selected in the
slicer, and the ranking is calculated by considering only the products that are active in the
filter context determined by these two models.
FIguRE 9-11 Ranking for products in two selected models.