Columns

Class name

Columns

Purpose / Description

This class contains methods and properties corresponding to columns.

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 columns that will be shown in the pivot table.

Default value:

--

Sample code:

myPivot.Columns.Fields = "State/Province"

Related to:

Rows.Fields

Order

Description:

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

Possible values:

• key_a_to_z
• value_a_to_z
• value_z_to_a

Default value:

key_a_to_z

Sample code:

myPivot.Columns.Order = key_a_to_z

Related to:

Rows.Order

ShowTotals

Description:

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

Default value:

True

Sample code:

myPivot.Columns.ShowTotals = True

Related to:

Rows.ShowTotals