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.

See CREATESLICEDEFINITION.

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.

Related topics