Contains the properties of a PivotTable field, field set, total, data field, or measure. The PLPivotField element is used to contain properties of automatic date fields.
Contained In
Subelements
For a PivotList component: BaseField, Caption, CurrentPage, DataField, DataType, DetailFormat, DetailWidth, DrilledLevel, Expanded, FilterCaption, Function, GroupedWidth, GroupType, Name, NewItemsHidden, NumberFormat, Orientation, ParentField, PivotItem, PLCaption, PLDataOrientation, PLGroupType, PLName, PLPosition, PLSubtotal, Position, ShowAllItems, SourceHierarchy, SourceHierarchyLevel, SourceName, Subtotal, SubtotalFormat, TotalAlignment, TotalCaptionAlignment, TotalWidth
For a workbook: AutoShowCount, AutoShowField, AutoShowRange, AutoShowType, AutoSortField, AutoSortOrder, BaseField, BaseItem, BlankLineAfterItems, Calculation, CantGetUniqueItems, Caption, CurrentPage, DataField, DataType, DrilledLevel, Formula, Function, GroupBy, GroupEnd, GroupEndAuto, GroupStart, GroupStartAuto, GroupType, LayoutForm, LayoutPageBreak, LayoutSubtotalLocation, MapChildItems, Name, NewItemsHidden, NoDragToColumn, NoDragToData, NoDragToHide, NoDragToPage, NoDragToRow, NumberFormat, Orientation, ParentField, PivotItem, Position, ServerBased, ServerSortOrder, ShowAllItems, SourceHierarchy, SourceHierarchyLevel, SourceName, SQLType, Subtotal, SubtotalName
Remarks
The Name subelement is required, and there can be more than one PivotItem subelement.
For a workbook, the BaseField subelement is required if the PivotField element describes a grouped field, or if the Calculation subelement contains one of the following string constants: DifferenceFrom, PercentOf, PercentDifferenceFrom, or RunningTotalIn. The BaseItem subelement is required if the Calculation subelement contains one of the following string constants: DifferenceFrom, PercentOf, or PercentDifferenceFrom. The ParentField subelement is required if the PivotField element describes an aggregate field. All other subelements are optional.
See the example in the PivotTable element topic.