Difference between revisions of "XL3RankLookup"

(Created page with 'Returns the member at the specified position of a ranking. Use the {{Menu|XLCubed|Insert Formula|Ranking}} menu or ribbon item to insert the formula using a wizard. ==Syntax== …')
 
(Added reference to XL3ValueRankLookup)
Line 1: Line 1:
Returns the member at the specified position of a ranking.
+
Returns the member at the specified position of a ranking. To return the value of the member instead, use the [[XL3ValueRankLookup|XL3ValueRankLookup formula]].
  
 
Use the {{Menu|XLCubed|Insert Formula|Ranking}} menu or ribbon item to insert the formula using a wizard.
 
Use the {{Menu|XLCubed|Insert Formula|Ranking}} menu or ribbon item to insert the formula using a wizard.
Line 48: Line 48:
 
==See Also==
 
==See Also==
 
* [[Formula Reference]]
 
* [[Formula Reference]]
 +
* [[XL3ValueRankLookup|XL3ValueRankLookup formula]]

Revision as of 13:55, 6 October 2010

Returns the member at the specified position of a ranking. To return the value of the member instead, use the XL3ValueRankLookup formula.

Use the XLCubed > Insert Formula > Ranking menu or ribbon item to insert the formula using a wizard.

Syntax

XL3RankLookup( Connection, Position, TopOrBottom, MaxCount, Measure, RankHierarchy, RankMembers, Hierarchy1, Member1,…, [Hierarchy11], [Member11] )

Parameters

Parameter Description
Connection Connection number to use
Position Position in the ranking to return
TopOrBottom Whether to return the highest values or the lowest. 0=Top 1=Bottom
MaxCount The maximum number of members to return in the ranking
Measure The measure on which to rank
RankHierarchy Name of the hierarchy that the member applies to e.g. "Measures" or "[Customer].[Customer Geography]"
RankMembers The member selection to use for ranking
Hierarchy1,…, HierarchyN The hierarchies to filter the ranking across
Member1,…, MemberN The members of the hierarchies used to filter the ranking across

Examples (based on the Bicycle Sales cube)

Returns 'AS800/195', the 2nd ranked product in the tuple ([Time].[2003], [KeyFigures].[Revenue], [Scenario].[Budget]).

=XL3RankLookup( 1, 2, 0, 10, "[Measures].[Value]", "Product", "[Product].[Product];levels", "Time", "2003", "KeyFigures", "Revenue", "Scenario", "Budget" )

See Also