Pivot Field Properties

Name

Returns

Description

AllItemsVisible

Boolean

A read-only Boolean set to True by default, this property checks whether manual filtering is applied to either a PivotField or a CubeField. This property is automatically set to False when any manual filtering is applied

AutoShowCount

Long

Read-only. Returns the number of top or bottom items that are automatically displayed in the PivotTable field

AutoShowField

String

Read-only. Returns the name of the data field used to figure out what top or bottom items to show automatically for a PivotTable field

AutoShowRange

Long

Read-only. Returns either xlTop if the top items are shown automatically or xlBottom if the bottom items are shown

Name

Returns

Description

AutoShowType

Long

Read-only. Returns either xlAutomatic if AutoShow is True or xlManual if AutoShow is disabled

AutoSortCustom Subtotal

Long

Read-only. Returns a value representing the type of operation used to automatically sort a given PivotField. The possible values are: 1 (Automatic), 2 (Sum), 3 (Count), 4 (Average), 5 (Max), 6 (Min), 7 (Product), 8 (Count Nums), 9 (StdDev), 10 (StdDevp), 11 (Var), and 12 (Varp)

AutoSortField

String

Read-only. Returns the data field name that will be used to sort the PivotTable field automatically

AutoSortOrder

XLSortOrder

Read-only. Returns one of the XLSortOrder constants specifying the automatic sort order type used for the field

AutoSortPivot Line

PivotLine

Read-only. Returns the name of the PivotLine used to sort the specified PivotTable field automatically

BaseField

Variant

Set/Get the base field used for a calculation. Data fields only

Baseltem

Variant

Set/Get the base item in the base field used for a calculation. Data fields only

Calculation

PivotField Calculation

Set/Get the type of calculation to do on the data field

Caption

String

Set/Get the text label to use for the field

ChildField

PivotField

Read-only. Returns the child field of the current field, if any

ChildItems

Variant

Read-only. Parameters: [Index]. Returns an object or collection containing a single Pivot-Table item (PivotItem) or group of Pivot-Table items (PivotItems) associated with the field

CubeField

CubeField

Read-only. Returns the cube field that the current PivotTable field comes from

CurrentPage

Variant

Set/Get the current page showing for the page field. Page fields only

CurrentPageList

Variant

Set/Get an array of strings corresponding to the list of items included in a multiple-item page field of a PivotTable report

Name

Returns

Description

CurrentPageName

String

Set/Get the displayed page of the PivotTable report

DatabaseSort

Boolean

Set/Get whether manual sorting and repositioning of data items in an OLAP PivotTable is allowed. Note that setting the DatabaseSort to either True or False causes an update

DataRange

Range

Read-only. Returns a range containing the data or items in the field

DataType

XlPivotField DataType

Read-only. Returns the data type of the PivotTable field

DisplayAsCaption

Boolean

Read-only. This property returns True when a given member property is used as a caption, and False when a member property PivotField is not used as caption

DisplayAsTooltip

Boolean

Read-only. This property returns True when a given member property is displayed in ToolTips, and False when a member property PivotField is not displayed in ToolTips

DisplayInReport

Boolean

Read-only. This property returns True when a given member property is displayed in the Pivot-Table, and False when a member property is not displayed in the PivotTable

DragToColumn

Boolean

Set/Get whether the field can be dragged to a column position

DragToData

Boolean

Set/Get whether the field can be dragged to the data position

DragToHide

Boolean

Set/Get whether the field can be dragged off the PivotTable report and therefore hidden

DragToPage

Boolean

Set/Get whether the field can be dragged to the page position

DragToRow

Boolean

Set/Get whether the field can be dragged to a row position

DrilledDown

Boolean

Set/Get whether the PivotTable field can be drilled down

EnableItem Selection

Boolean

Set/Get whether the ability to use the field drop-down in the user interface is enabled

Enable

Multiple

PageItems

Boolean

Set/Get whether checkboxes are enabled in the drop-down boxes of the fields in the PivotTable's Filter area

Name

Returns

Description

Formula

String

Set/Get the formula associated with the field, if any

Function

Consolidation Function

Set/Get the type of function used to summarize the PivotTable field

GroupLevel

Variant

Read-only. Returns how the field is placed within a group of fields

Hidden

Boolean

Set/Get whether a given level in an OLAP hierarchy is visible. Set this property to True to hide levels, and False to make them visible

Hiddenltems

Variant

Read-only. Parameters: [Index]. Returns an object or collection containing a single hidden PivotTable item (PivotItem) or group of hidden PivotTable items (PivotItems) associated with the field

HiddenltemsList

Variant

Set/Get an array of strings that are hidden items for the PivotField

IncludeNewltems InFilter

Boolean

Set/Get whether excluded or included items should be tracked when manual filtering is applied to a given PivotField. Set this property to True to keep track of excluded items, and set to False to keep track of included items

IsCalculated

Boolean

Read-only. Returns whether the PivotTable field is calculated

IsMember Property

Boolean

Read-only. Returns whether the PivotField contains member properties

LabelRange

Range

Read-only. Returns the cell range containing the field's label

LayoutBlankLine

Boolean

Set/Get whether a blank row is added just after the current row field

LayoutCompactRow

Boolean

Set/Get whether a given PivotField is compacted when rows are selected

LayoutForm

XlLayoutForm Type

Set/Get how the items will appear in the field

LayoutPage Break

Boolean

Set/Get whether a page break is inserted after each field

LayoutSubtotal Location

XlSubtotal LocationType

Set/Get the location for the field subtotals as compared to the current field

Name

Returns

Description

MemberProperty Caption

String

Set/Get which member property is used as caption for a given level. Note that this setting only has a visual effect when the UseMember-PropertyAsCaption property is set to True for the PivotField

MemoryUsed

Long

Read-only. Returns the number of bytes of computer memory being used for the field

Name

String

Set/Get the name of the field

NumberFormat

String

Set/Get the format used for numbers in the field

Orientation

XlPivotField Orientation

Set/Get where the field is located in the PivotTable report

ParentField

PivotField

Read-only. Returns the parent field of the current field, if any

ParentItems

Variant

Read-only. Parameters: [Index]. Returns an object or collection containing a single parent PivotTable item (Pivotltem) or group of parent PivotTable items (Pivotltems) associated with the field

PivotFilters

Variant

Sets/Gets the PivotFilters for a given Pivot-Field

Position

Variant

Set/Get the position number of the field among all the fields in the same orientation

PropertyOrder

Long

Set/Get the display position of the member property within the cube field to which it belongs (setting will rearrange the order). Valid only for PivotField objects that are member property fields

PropertyParent Field

PivotField

Read-only. Returns the field to which the properties in this field are linked

ServerBased

Boolean

Set/Get whether only items that match the page field selection are retrieved from the external data source

ShowAllItems

Boolean

Set/Get whether all items in the field are displayed

ShowingInAxis

Boolean

Read-only. Returns True if the PivotField is currently visible and returns False if the PivotField is currently not visible

SourceCaption

Variant

Read-only. Returns the original caption as it existed on the OLAP server for a given PivotField

Name

Returns

Description

SourceName

String

Read-only. Returns the name of the source data for the field

StandardFormula

String

Set/Get the formulas with standard U.S. formatting

SubtotalName

String

Set/Get the label used for the subtotal column or row for this field

Subtotals

Variant

Parameters: [Index]. Set/Get the subtotals displayed for the field

TotalLevels

Variant

Read-only. Returns the total number of fields in the current field group

UseMember

PropertyAs

Captions

Boolean

Set/Get whether member property captions are used for captions in a given PivotField. If set to True, then the MemberPropertyCaption property is used to define which member property caption to display. If none is specified, then the first member property of that PivotField (in data source order) will be displayed as the caption for items of that PivotField

Value

String

Set/Get the name of the field

VisibleItems

Variant

Read-only. Parameters: [Index]. Returns an object or collection containing a single visible PivotTable item (PivotItem) or group of visible PivotTable items (PivotItems) associated with the field

VisibleItemsList

Variant

Set/Get an array that represents the included items in the manual filter applied to a given PivotField

Ultimate Blackjack System

Ultimate Blackjack System

Discover the 100 Legal Secrets Las Vegas Professional Blackjack Gamblers Use to Make Literally Thousands of Dollars Every Week... I'll Teach You the Ultimate Step-by-Step Blackjack System, Casino's Don't Want You to Know About! That's Right, I'll show you step-by-step how to have the blackjack odds in your favor, guaranteed!

Get My Free Ebook


Post a comment