Specifies the location of the field in a PivotTable report.

Name Value Description
xlColumnField 2 Specifies the Column field.
xlDataField 4 Specifies the Data field.
xlHidden 0 Specifies that the field is hidden.
xlPageField 3 Specifies the Page field.
xlRowField 1 Specifies the Row field.