Database Reference
In-Depth Information
Measures.[Internet Sales Amount]
),
Format_String = "Percent",
Associated_Measure_Group = "Internet
Sales",
Non_Empty_Behavior = [Internet Sales
Amount]
6. Switch to SSMS and execute the following query to see the calculated meas-
ure in action. The result will be a list of each product's subcategory that had
sales ordered by the internet sales amount, along with the percentage of con-
tribution to the total internet sales amount:
SELECT {measures.[Internet Ratio to All
Products], measures.[internet sales
amount]} ON 0,
ORDER (FILTER (product.[product
categories].[subcategory].members, NOT
ISEMPTY(measures.[Internet Sales
Amount])),
Measures.[Internet Sales Amount], DESC)
ON 1
FROM [Adventure Works]
Search WWH ::
Custom Search