ADDSLICEAXISVALUESORT
Modifies an existing slice axis with the addition of sorting by value. To add sorting to a slice, use the modified axis when you create a slice definition.
Syntax
=ADDSLICEAXISVALUESORT("Axis","Tuple","Break Hierarchy","Order ASC/DESC")
.
The function returns #{Axis}
.
Example
In this example, cell F22 holds the result of a CREATESLICEAXIS function.
This function sorts values by period in descending order. 'True' specifies that the hierarchy is broken:
=ADDSLICEAXISVALUESORT(F22,"[Period].[All Years]","True","Desc")