CREATESLICETUPLESEGMENTS
This function creates multiple segments. It is an alternative to creating multiple individual segments with CREATESLICELISTSEGMENT.
Syntax
=CREATESLICETUPLESEGMENTS(hierarchies,Array_of_array_elements)
Example
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 #(Segment)
.