Rows

Class name

Rows

Purpose / Description

This class contains methods and properties corresponding to rows.

Methods

• none

Properties

• Fields
• Order
• ShowTotals

Detailed description

The following sections contain a detailed description of the properties and methods.

Fields

Description:

With this property you can specify the rows that will be shown in the pivot table.

Default value:

--

Sample code:

myPivot.Columns= "Product ID"

Related to:

Columns.Fields

Order

Description:

With this property you can control the sort order of the rows.

Possible values:

• key_a_to_z
• value_a_to_z
• value_z_to_a

Default value:

key_a_to_z

Sample code:

myPivot.Rows.Order = key_a_to_z

Related to:

Columns.Order

ShowTotals

Description:

With this property you can control whether the totals for the rows are shown in the pivot table or not.

Default value:

True

Sample code:

myPivot.Rows.ShowTotals = True

Related to:

Columns.ShowTotals