MDX - SQL Server Analysis Services 2012 Cube Development - page 224

product.[product
categories].[category]).name
SELECT {measures.category,
measures.[reseller sales amount],
measures.[sum for category]} ON 0,
FILTER([Product].[Product
Categories].product.members,
measures.[reseller sales amount]>=
(measures.[sum for category] * 0.1)) ON 1
FROM [Adventure Works]
WHERE
[Date].[Calendar].[Month].&[2008]&[5]

Reseller Sales
Amount

Sum for Cat-
egory Products Category

Hitch Rack - 4-Bike Accessories $6,400.32 $12,272.04

Sport-100 Helmet, Blue Accessories $1,343.59 $12,272.04

Hydration Pack - 70 oz. Accessories $1,861.54 $12,272.04

Short-Sleeve Classic Jer-
sey, XL

Clothing $3,055.57 $23,549.22

Women's Mountain
Shorts, L

Clothing $3,121.39 $23,549.22