PIVOT.ITEM

Macro Sheets Only

Moves an item within a PivotTable.

Syntax

PIVOT.ITEM(name, pivot_field_name, pivot_item_name,position)

Name is the name of the PivotTable within which an item will be repositioned. If name is omitted, Microsoft Excel will use the PivotTable containing the active cell.

Pivot_field_name is the name of the field within which an item will be repositioned, given as a text string. If pivot_field_name is omitted, Microsoft Excel will use the field containing the active cell. If the active cell is not within a field, then this argument is required.

Pivot_item_name is the name of the item to be repositioned in its field (given as a text constant). If it is omitted, Microsoft Excel uses the item containing the active cell. If the active cell is not contained within an item, then this argument is requiried.

Position is a number representing where in the field the items will be moved. Position 1 is the topmost position within the row field and the leftmost position within the column field and the highest position within the page field. If the position argument is omitted, it will default to the last position in the field.

Remarks

• If an item is set to be visible, but its display is supressed because there is no data, this item still occupies a valid position.
• If name is not a valid PivotTable name then the #VALUE! error value is returned.
• If pivot_field_name is not a text string, or if pivot_field_name is not a text string within a valid field name, then #VALUE! is returned.
• If pivot_item_name is an item which is not currently showing in the PivotTable because it does not exist in the field pivot_field_name, the #VALUE! error value is returned.

Related Functions

PIVOT.ADD.DATA Adds a field to a PivotTable as a Data Field

PIVOT.ADD.FIELDS Adds fields to a PivotTable

PIVOT.FIELD Pivots fields within a PivotTable

PIVOT.FIELD.GROUP Creates groups within a PivotTable

PIVOT.FIELD.PROPERTIES Changes the properties of a field inside a PivotTable

PIVOT.FIELD.UNGROUP Ungroups all selected groups within a PivotTable

PIVOT.ITEM.PROPERTIES Changes the properties of an item within a header field

PIVOT.REFRESH Refreshes a PivotTable

PIVOT.SHOW.PAGES Creates new sheets in the workbook containing the active cell

PIVOT.TABLE.WIZARD Creates an empty PivotTable

List of Command-Equivalent Functions