Syntax

expression.PageFieldWrapCount

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.

Visual Basic for Applications
With Worksheets(1).PivotTables("Pivot1") .PageFieldOrder = xlOverThenDown .PageFieldWrapCount = 3 End With
get count pivot table page fields in row page field wrap count Page Field Wrap Count Property pagefieldwrap PageFieldWrapCount pagefieldwrapcount property set number pivot table page fields in each column

See also: