PivotTable.PageFieldOrder (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.

ActiveCell.PivotTable.PageFieldOrder = xlOverThenDown