PivotTable Field Settings Dialog

  • 2 min to read

The Field Settings dialog allows end-users to rename a PivotTable row or column field and adjust its subtotal and layout settings.

End-users can invoke this dialog by doing the following:

  • Select a row or column field;
  • Right-click it and select the Field Settings... item from the context menu...

    DXSpreadsheet_Dialogs_FieldSettings_ContextMenu

  • ... or click the Field Settings button on the ribbon. Add the Active Field ribbon group to enable this button (check the Lesson 1 - Create a Simple Spreadsheet topic for details on how to provide a Ribbon UI for the SpreadsheetControl).

    DXSpreadsheet_Dialogs_FieldSettings_Ribbon

The Field Settings dialog includes the following tabs.

Subtotals & Filters

DXSpreadsheet_Dialogs_FieldSettings_SubtotalFilter

Options under this tab enable end-users to subtotal row or column fields.

End-users can select one of the following subtotal options:

Checking the Include new items in the manual filter box (PivotField.IncludeNewItemsInFilter) enables adding the new PivotTable items to a manual filter.

Layout & Print

DXSpreadsheet_Dialogs_FieldSettings_LayoutPrint

Options under this tab allows end-users to change the layout form for an outer row field.

  • Show item labels in the outline form (PivotFieldLayout.Outline is true) - outlines row data.

    DXSpreadsheet_Dialogs_FieldSettings_Outline

    Check the Display labels from the next field in the same column (compact form) box to compress the current and next row fields, as shown on the image below.

    DXSpreadsheet_Dialogs_FieldSettings_CompactForm

    Checking the Display subtotals at the top of each group box moves subtotals to the top of each item in the row field if it's shown in compact or outline form.

  • Show items in tabular form (PivotFieldLayout.Outline is false) - shows the row field in table format.

    DXspreadsheet_Dialogs_FieldSettings_Tabular

The Layout & Print tab also allows end-users to specify whether to repeat item labels for an outer field (PivotFieldLayout.RepeatItemLabels), insert a blank line after each field item (PivotFieldLayout.InsertBlankRowAfterEachItem), or show items with no data (PivotFieldLayout.ShowItemsWithNoData).

TIP

Call the PivotField.SetSubtotal method to set subtotals in code. Use properties of the PivotFieldLayout object to change the layout of a specific field in the report. Refer to the How to: Subtotal Fields in a Pivot Table or How to: Change the PivotTable Layout topic for details.