The Item function returns a tuple from the specified set. There are three possible ways to call the Item function:

If a single string expression is specified, the Item function returns the specified tuple. For example, "([2005].Q3, [Store05])".

If more than one string expression is specified, the Item function returns the tuple defined by the specified coordinates. The number of strings must match the number of axis, and each string must identify a unique hierarchy. For example, "[2005].Q3", "[Store05]".

If an integer is specified, the Item function returns the tuple that is in the zero-based position specified by Index.

Examples

The following example returns ([1996],Sales):

{([1996],Sales), ([1997],Sales), ([1998],Sales)}.Item(0)

The following example uses a level expression and returns the Internet Sales Amount for each State-Province in Australia and its percent of the total Internet Sales Amount for Australia. This example uses the Item function to extract the first (and only tuple) from the set returned by the Ancestors function.