-
Notifications
You must be signed in to change notification settings - Fork 63
/
excel.interfaces.datapivothierarchydata.yml
100 lines (100 loc) · 3.9 KB
/
excel.interfaces.datapivothierarchydata.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
### YamlMime:TSType
name: Excel.Interfaces.DataPivotHierarchyData
uid: 'excel!Excel.Interfaces.DataPivotHierarchyData:interface'
package: excel!
fullName: Excel.Interfaces.DataPivotHierarchyData
summary: An interface describing the data returned by calling `dataPivotHierarchy.toJSON()`<!-- -->.
remarks: ''
isPreview: false
isDeprecated: false
type: interface
properties:
- name: field
uid: 'excel!Excel.Interfaces.DataPivotHierarchyData#field:member'
package: excel!
fullName: field
summary: Returns the PivotFields associated with the DataPivotHierarchy.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'field?: Excel.Interfaces.PivotFieldData;'
return:
type: '<xref uid="excel!Excel.Interfaces.PivotFieldData:interface" />'
- name: id
uid: 'excel!Excel.Interfaces.DataPivotHierarchyData#id:member'
package: excel!
fullName: id
summary: ID of the DataPivotHierarchy.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'id?: string;'
return:
type: string
- name: name
uid: 'excel!Excel.Interfaces.DataPivotHierarchyData#name:member'
package: excel!
fullName: name
summary: Name of the DataPivotHierarchy.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'name?: string;'
return:
type: string
- name: numberFormat
uid: 'excel!Excel.Interfaces.DataPivotHierarchyData#numberFormat:member'
package: excel!
fullName: numberFormat
summary: Number format of the DataPivotHierarchy.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'numberFormat?: string;'
return:
type: string
- name: position
uid: 'excel!Excel.Interfaces.DataPivotHierarchyData#position:member'
package: excel!
fullName: position
summary: Position of the DataPivotHierarchy.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'position?: number;'
return:
type: number
- name: showAs
uid: 'excel!Excel.Interfaces.DataPivotHierarchyData#showAs:member'
package: excel!
fullName: showAs
summary: Specifies if the data should be shown as a specific summary calculation.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'showAs?: Excel.ShowAsRule;'
return:
type: '<xref uid="excel!Excel.ShowAsRule:interface" />'
- name: summarizeBy
uid: 'excel!Excel.Interfaces.DataPivotHierarchyData#summarizeBy:member'
package: excel!
fullName: summarizeBy
summary: Specifies if all items of the DataPivotHierarchy are shown.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: >-
summarizeBy?: Excel.AggregationFunction | "Unknown" | "Automatic" | "Sum" | "Count" | "Average" | "Max" | "Min"
| "Product" | "CountNumbers" | "StandardDeviation" | "StandardDeviationP" | "Variance" | "VarianceP";
return:
type: >-
<xref uid="excel!Excel.AggregationFunction:enum" /> | "Unknown" | "Automatic" | "Sum" | "Count" | "Average" |
"Max" | "Min" | "Product" | "CountNumbers" | "StandardDeviation" | "StandardDeviationP" | "Variance" |
"VarianceP"