ADDSLICEAXISATTRIBUTES

Modifies an existing slice axis by the addition of attributes. Use the modified axis when you create a slice definition.

See CREATESLICEDEFINITION.

Syntax

=ADDSLICEAXISATTRIBUTES("Axis", "Array of hierarchies","Attribute names per hierarchy","separator")

Example

Cell F22 contains an axis created with CREATESLICEAXIS.

See CREATESLICEAXIS.

Cells F5 and F6 each contain a hierarchy. For example [channel] and [product].

Cells H5 and H6 each contain the attributes to assign to the hierarchies in F5 and F6. For example, F5 contains ATT1_Manager,ATT1_Headcount and F6 contains ATT1_Name, ATT1_OrderPos.

The function =ADDSLICEAXISATTRIBUTES(F22,F5:F6,H5:H6,",") returns #{Axis}.

Related topics