INSERTSLICEAXISRANKING

This function modifies an existing slice axis by adding ranking by value. To add ranking to a slice, use the modified axis when you create a slice definition.

These functions have a similar purpose:

• ADDSLICEAXISRANKING
• INSERTSLICEAXISRANKING

The difference between the two functions is in the order in which they add ranking criteria to the MDX definition of a slice. The order in which criteria are added determines the order in which they are applied and can, therefore, affect how a slice is sorted and ranked.

ADDSLICEAXISRANKING adds ranking to the end of the list of criteria. INSERTSLICEAXISRANKING adds ranking to the beginning of the list of criteria.

Syntax

=ADDSLICEAXISRANKING(axis,"tuple","ranking",[ranking_count]).

These rankings are valid:

• None
• TopCount
• BottomCount
• TopPercent
• BottomPercent
• TopSum
• BottomSum