CREATESLICETUPLESEGMENTS
Creates multiple segments. It is an alternative to creating multiple individual segments with CREATESLICELISTSEGMENT.
Syntax
=CREATESLICETUPLESEGMENTS("Array of
hierarchies","Array of array of elements")
Example
This example is based on the Best Practices Templates sample database.
Cells A5 and A6 each contain a hierarchy. For example,
[period] and [pos]
.
Cell A7 contains
=A5:A6
. The cell displays the array of the hierarchies
in A5 and A6. For example, #("[period]","[pos]")
.
Cells H5 and H6 each contain an array of elements. That is, the unique names of two or more elements, separated by commas.
Cell H7 contains
=H5:H6
. The cell displays an array which contains the
arrays of elements in H5 and H6.
The function
=CREATESLICETUPLESEGMENTS(A7,H7)
returns
#(Segments)
.