PivotTable.PageFieldOrder Property (Excel)
Returns or sets the order in which page fields are added to the PivotTable report’s layout. Can be one of the following XlOrder constants: xlDownThenOver or xlOverThenDown. The default constant is xlDownThenOver. Read/write Long.
Syntax
expression .PageFieldOrder
expression A variable that represents a PivotTable object.
Example
This example causes the PivotTable report to draw three page fields in a row before starting a new row.
With Worksheets(1).PivotTables("Pivot1")
.PageFieldOrder = xlOverThenDown
.PageFieldWrapCount = 3
End With