Database Reference
In-Depth Information
Reseller Sales Amount
Corner Bicycle Supply
$616,663.89
Retail Mall
$611,102.67
5. So far so good. Now let's limit the query to calendar year 2007 and check the
results again:
SELECT measures.[reseller sales amount]
ON 0,
[leading resellers] ON 1
FROM [Adventure Works]
WHERE [Date].[Calendar].[Calendar
Year].&[2007]
Reseller Sales Amount
Metropolitan Equipment
$307,274.84
Corner Bicycle Supply
$315,833.45
Retail Mall
$291,364.58
6. So, we got the same three resellers. They must have had the highest reseller
sales amounts for 2007 as well, right? Wrong. We can easily double-check
Search WWH ::
Custom Search