ADDSLICEAXISATTRIBUTES

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

Syntax

=ADDSLICEAXISATTRIBUTES(axis, hierarchies",attribute_names_ per_hierarchy,"separator")

Example

Cell F22 contains an axis created with CREATESLICEAXIS. The cell displays #{Axis}.

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}.