2.1.786 Part 4 Section 3.10.1.33, filter (PivotTable Advanced Filter)

a.   The standard does not define a maximum value for @fld.

Office requires @fld to be less than the pivotFields count.

b.   The standard does not define a max value for @iMeasureHier.

Office requires that @iMeasureHier be less than the pivotHierarchies count.

c.   The standard does not define a maximum value for the mpFld attribute.

Office requires that the mpFld attribute be less than the pivotFields count.

d.   The standard does not specify a default value for the iMeasureFld attribute.

Excel uses a default value of 0 for this attribute.

e.   The standard does not state a maximum limit for the iMeasureFld attribute.

Office specifies that @iMeasureFld be less than the data fields count. Office will not load a file that has @iMeasureFld greater or equal to the count of pivotFields.

f.   The standard does not state any restrictions on when the mpFld attribute can be used.

Office assumes that the mpFld attribute is specific to OLAP PivotTables.

g.   The standard states that @evalOrder specifies the evaluation order of the pivot filter.

In Office, the value of -1 indicates that the order in which filters are applied is not relevant.

Show: