subset

Returns a subset of members in "set_expression" starting at "index_expression1" from the beginning. If the count "index_expression2" is specified, that many members are returned (if available). Otherwise, all remaining members are returned.

Syntax

subset ( set_expression, index_expression1 [ , index_expression2 ] )

Example 1

subset ( members ( [great_outdoors_company].[Products].[Products].
[Product line] ) , 2 )

Result

Returns the members of the Product line set starting at the second member.

Result data

Mountaineering Equipment
Outdoor Protection
Personal Accessories

Example 2

subset ( members ( [great_outdoors_company].[Products].[Products].
[Product line] ) , 2 , 2 )

Result

Returns two members of the Product line set starting at the second member.

Result data

Mountaineering Equipment
Outdoor Protection