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.

See CREATESLICEDEFINITION.

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")