RowAxis Property

PivotData object: Returns a PivotResultRowAxis object that represents the row axis.

PivotView object: Returns a PivotGroupAxis object that represents the row axis.

expression   Required. An expression that returns one of the object in the Applies To list.

Example

This example inserts two field sets into the PivotTable list in the active view.

Sub AddFieldsToPT()

   Dim ptView

   Set ptView = PivotTable1.ActiveView

   ptView.ColumnAxis.InsertFieldSet ptView.FieldSets("Store Type")

   ptView.RowAxis.InsertFieldSet ptView.FieldSets("Promotions")

End Sub