-
Notifications
You must be signed in to change notification settings - Fork 62
/
excel.pivotfiltertype.yml
54 lines (47 loc) · 2 KB
/
excel.pivotfiltertype.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
### YamlMime:TSEnum
name: Excel.PivotFilterType
uid: 'excel!Excel.PivotFilterType:enum'
package: excel!
fullName: Excel.PivotFilterType
summary: A simple enum that represents a type of filter for a PivotField.
remarks: '\[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
fields:
- name: date
uid: 'excel!Excel.PivotFilterType.date:member'
package: excel!
summary: >-
Filters PivotItems with a date in place of a label. Note: A PivotField cannot simultaneously have a label filter
and a date filter applied.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Date"'
- name: label
uid: 'excel!Excel.PivotFilterType.label:member'
package: excel!
summary: >-
Filters PivotItems based on their labels. Note: A PivotField cannot simultaneously have a label filter and a date
filter applied.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Label"'
- name: manual
uid: 'excel!Excel.PivotFilterType.manual:member'
package: excel!
summary: |-
Filters specific manually selected PivotItems from the PivotTable.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Manual"'
- name: unknown
uid: 'excel!Excel.PivotFilterType.unknown:member'
package: excel!
summary: |-
`PivotFilterType` is unknown or unsupported.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Unknown"'
- name: value
uid: 'excel!Excel.PivotFilterType.value:member'
package: excel!
summary: |-
Filters based on the value of a PivotItem with respect to a `DataPivotHierarchy`<!-- -->.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Value"'