Database Reference
In-Depth Information
13. From the
Product
table, select the
EnglishProductName
field to be ad-
ded to
ROWS
under the
FullDate
field.
14. From the
Internet Sales
measure table at the top of the fields list, select
the following measures:
•
Order Quantity
•
Qty Ratio Over Reorder Point
•
Last Order Qty Ratio Over Reorder Point
15. Use the slicer to select different years. Also, use the clear all icon at the top-
right corner of the slicer to release the filter and include all the years. The
time to run each query may vary from one to multiple seconds.
You will use this PivotTable to capture the query that Excel generates when you in-
teract with slicers and other elements used to browse the Tabular Model.
Search WWH ::
Custom Search