Example
First consider the following query and the results it returns:
SELECT MEASURES.[%COUNT] ON 0,
BOTTOMCOUNT(birthd.decade.MEMBERS, 100, MEASURES.[%COUNT]) ON 1
FROM patients
Patient Count
1 1910s 71
2 2010s 155
3 1920s 223
4 1930s 572
5 1940s 683
6 1950s 1,030
7 1980s 1,400
8 1990s 1,413
9 2000s 1,433
10 1960s 1,500
11 1970s 1,520
Because count_expression is greater than the number of members, all members are returned. The members are sorted in ascending order according to the value of the %COUNT measure.
Next, consider a similar query, using count_expression equal to 3:
SELECT MEASURES.[%COUNT] ON 0,
BOTTOMCOUNT(birthd.decade.MEMBERS, 3, MEASURES.[%COUNT]) ON 1
FROM patients
Patient Count
1 1910s 71
2 2010s 155
3 1920s 223
This query selects three members from the lower-valued end of the set.