The query below returns 10 products that have the lowest Internet Sales Amount. Notice that all records returned are null. To get the lowest 10 products that have a value, see the next query.
|
|
SELECT {[Measures].[Internet Sales Amount]} ON COLUMNS,
BOTTOMCOUNT([Product].[Product].Members
,10
, [Measures].[Internet Sales Amount]) ON ROWS
FROM [Adventure Works]
|
|
|
|
|
|
|
This query returns the 10 products (that are non empty) that have the lowest Internet Sales Amount. |
|
SELECT {[Measures].[Internet Sales Amount]} ON COLUMNS,
BOTTOMCOUNT(FILTER([Product].[Product].Members, NOT ISEMPTY([Measures].[Internet Sales Amount]))
, 10
, [Measures].[Internet Sales Amount]) ON ROWS
FROM [Adventure Works]
|
|
|
|
|
|
|