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