ADDSLICEAXISRANKING
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.
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