ADDSLICEAXISATTRIBUTESORT
Modifies an existing slice axis with the addition of sorting by attribute. To add sorting to a slice, use the modified axis when you create a slice definition.
Syntax
=ADDSLICEAXISATTRIBUTESORT("Axis","Hierarchy","Attribute","Break
Hierarchy","Order ASC/DESC")
The function returns
#{Axis}
.
Example
In this example, cell F22 holds the result of a CREATESLICEAXIS function:
=ADDSLICEAXISATTRIBUTESORT(F22,"Product","Attr1","True","Desc")
Sorting is by Attribute1. 'True' specifies that the hierarchy is broken and 'Desc' that it is sorted in descending order.