[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

Value
Meaning
"0"	Each member from a different level of the same PivotTable cache hierarchy of this PivotTable named set is displayed in a separate PivotTable field (1).
"1"	All members from different levels of the same PivotTable cache hierarchy of this PivotTable named set are displayed in the same PivotTable field (1).

dynamicSet: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this PivotTable named set is a dynamic OLAP named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").

Value	Meaning
"0"	This PivotTable named set is a static OLAP named set.
"1"	This PivotTable named set is a dynamic OLAP named set.

hierarchizeDistinct: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to automatically order and remove duplicates from this PivotTable named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").