Excel.Interfaces.DataPivotHierarchyData interface
An interface describing the data returned by calling dataPivotHierarchy.toJSON().
Properties
| field | Returns the PivotFields associated with the DataPivotHierarchy. |
| id | ID of the DataPivotHierarchy. |
| name | Name of the DataPivotHierarchy. |
| number |
Number format of the DataPivotHierarchy. |
| position | Position of the DataPivotHierarchy. |
| show |
Specifies if the data should be shown as a specific summary calculation. |
| summarize |
Specifies if all items of the DataPivotHierarchy are shown. |
Property Details
field
Returns the PivotFields associated with the DataPivotHierarchy.
field?: Excel.Interfaces.PivotFieldData;Property Value
Remarks
id
name
numberFormat
Number format of the DataPivotHierarchy.
numberFormat?: string;Property Value
string
Remarks
position
Position of the DataPivotHierarchy.
position?: number;Property Value
number
Remarks
showAs
Specifies if the data should be shown as a specific summary calculation.
showAs?: Excel.ShowAsRule;Property Value
Remarks
summarizeBy
Specifies if all items of the DataPivotHierarchy are shown.
summarizeBy?: Excel.AggregationFunction | "Unknown" | "Automatic" | "Sum" | "Count" | "Average" | "Max" | "Min" | "Product" | "CountNumbers" | "StandardDeviation" | "StandardDeviationP" | "Variance" | "VarianceP";Property Value
Excel.AggregationFunction | "Unknown" | "Automatic" | "Sum" | "Count" | "Average" | "Max" | "Min" | "Product" | "CountNumbers" | "StandardDeviation" | "StandardDeviationP" | "Variance" | "VarianceP"