| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
XL3RankLookup
Revision as of 14:55, 6 October 2010 by Antonio.remedios (talk | contribs) (Added reference to XL3ValueRankLookup)
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" )
