Database Reference
In-Depth Information
measures.[top selling product for
category],
measures.[product's reseller sales amount]
} ON 1
FROM [Adventure Works]
WHERE
[Date].[Calendar].[Month].&[2008]&[5]
The result is as follows:
Accessories Bikes
Clothing Components
Reseller Sales
Amount
$12,272.04 $837,984.79 $23,549.22 $156,572.02
top selling
product for cat-
egory
Hitch Rack -
4-Bike
Mountain-200
Black, 38
Classic
Vest, S
HL Touring
Frame - Yellow,
54
product's re-
seller sales
amount
$6,400.32
$57,741.95 $3,703.37 $13,853.96
Search WWH ::




Custom Search