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