2.5.104 PivotFilterType
PivotFilterType is a 4-byte unsigned integer that specifies the type of advanced PivotTable (section 2.1.7.40) filter. It is used by the BrtBeginSXFILTER (section 2.4.247) record. This value MUST correspond to the Value column in the following table.
|
Category |
Value |
Meaning |
|---|---|---|
|
Value Filter |
0x00000001 |
"count" filter |
|
Value Filter |
0x00000002 |
"percent" filter for numeric values |
|
Value Filter |
0x00000003 |
"sum" filter for numeric values |
|
Label Filter |
0x00000004 |
"equals" filter for field captions |
|
Label Filter |
0x00000005 |
"not equal" filter for field captions |
|
Label Filter |
0x00000006 |
"begins with" filter for field captions |
|
Label Filter |
0x00000007 |
"does not begin with" filter for field captions |
|
Label Filter |
0x00000008 |
"ends with" filter for field captions |
|
Label Filter |
0x00000009 |
"does not end with" filter for field captions |
|
Label Filter |
0x0000000A |
"contains" filter for field captions |
|
Label Filter |
0x0000000B |
"does not contain" filter for field captions |
|
Label Filter |
0x0000000C |
"is greater than" filter for field captions |
|
Label Filter |
0x0000000D |
"is greater than or equal to" filter for field captions |
|
Label Filter |
0x0000000E |
"is less than" filter for field captions |
|
Label Filter |
0x0000000F |
"is less than or equal to" filter for field captions |
|
Label Filter |
0x00000010 |
"is between" filter for field captions |
|
Label Filter |
0x00000011 |
"is not between" filter for field captions |
|
Value Filter |
0x00000012 |
"value equal" filter for text and numeric values |
|
Value Filter |
0x00000013 |
"value not equal" filter for text and numeric values |
|
Value Filter |
0x00000014 |
"value greater than" filter for text and numeric values |
|
Value Filter |
0x00000015 |
"value greater than or equal to" filter for text and numeric values |
|
Value Filter |
0x00000016 |
"value less than" filter for text and numeric values |
|
Value Filter |
0x00000017 |
"value less than or equal to" filter for text and numeric values |
|
Value Filter |
0x00000018 |
"value between" filter for text and numeric values |
|
Value Filter |
0x00000019 |
"value not between" filter for text and numeric values |
|
Date Filter |
0x0000001A |
"equals" filter for date values |
|
Date Filter |
0x0000001B |
"older than" filter for date values |
|
Date Filter |
0x0000001C |
"newer than" filter for date values |
|
Date Filter |
0x0000001D |
"between" filter for date values |
|
Date Filter |
0x0000001E |
"tomorrow" filter for date values |
|
Date Filter |
0x0000001F |
"today" filter for date values |
|
Date Filter |
0x00000020 |
"yesterday" filter for date values |
|
Date Filter |
0x00000021 |
"next week" filter for date values |
|
Date Filter |
0x00000022 |
"this week" filter for date values |
|
Date Filter |
0x00000023 |
"last week" filter for date values |
|
Date Filter |
0x00000024 |
"next month" filter for date values |
|
Date Filter |
0x00000025 |
"this month" filter for date values |
|
Date Filter |
0x00000026 |
"last month" filter for date values |
|
Date Filter |
0x00000027 |
"next quarter" filter for date values |
|
Date Filter |
0x00000028 |
"this quarter" filter for date values |
|
Date Filter |
0x00000029 |
"last quarter" filter for date values |
|
Date Filter |
0x0000002A |
"next year" filter for date values |
|
Date Filter |
0x0000002B |
"this year" filter for date values |
|
Date Filter |
0x0000002C |
"last year" filter for date values |
|
Date Filter |
0x0000002D |
"year-to-date" filter for date values |
|
Date Filter |
0x0000002E |
"first quarter" filter for date values |
|
Date Filter |
0x0000002F |
"second quarter" filter for date values |
|
Date Filter |
0x00000030 |
"third quarter" filter for date values |
|
Date Filter |
0x00000031 |
"fourth quarter" filter for date values |
|
Date Filter |
0x00000032 |
"January" filter for date values |
|
Date Filter |
0x00000033 |
"February" filter for date values |
|
Date Filter |
0x00000034 |
"March" filter for date values |
|
Date Filter |
0x00000035 |
"April" filter for date values |
|
Date Filter |
0x00000036 |
"May" filter for date values |
|
Date Filter |
0x00000037 |
"June" filter for date values |
|
Date Filter |
0x00000038 |
"July" filter for date values |
|
Date Filter |
0x00000039 |
"August" filter for date values |
|
Date Filter |
0x0000003A |
"September" filter for date values |
|
Date Filter |
0x0000003B |
"October" filter for date values |
|
Date Filter |
0x0000003C |
"November" filter for date values |
|
Date Filter |
0x0000003D |
"December" filter for date values |
|
Date Filter |
0x0000003E |
"not equal" filter for date values |
|
Date Filter |
0x0000003F |
"older than or equal to" filter for date values |
|
Date Filter |
0x00000040 |
"newer than or equal to" filter for date values |
|
Date Filter |
0x00000041 |
"not between" filter for date values |