Field settings

Use the Field Settings dialog box to control various format, print, subtotal, and filter settings for a field in a PivotTable report.

Source Name    Displays the name of the field in the data source.

Custom Name     Displays the current field name in the PivotTable report, or the source name if there is no custom name. To change the Custom Name, click the text in the box and edit the name.

Layout & Print

Layout section

Show item labels in outline form    Click to show field items in outline form.

Display labels from the next field in the same column (compact form)    Select or clear to display or hide labels from the next field in the same column or compact form. This switches compact form on or off for the selected field. This check box is enabled only when you have selected Show items in outline form.

Display subtotals at the top of each group    Select or clear to display subtotals at the top of each group. This check box is enabled only when you have selected Show items in outline form.

Show item labels in tabular form    Click to show field items in tabular form. This setting only affects fields in the row labels area.

Insert blank line after each item    Select to provide more spacing between items, such as subtotals, by inserting a blank line after each item. Clear this check box to display field items without blank lines.

Note: You can apply character and cell formatting to the blank rows, but you can't enter data in them.

Show items with no data    Select or clear to show or hide items with no data.

Note: This check box is not available for an OLAP data source.

Print section

Insert page break after each item    Select or clear to insert or not insert a page break after each item when printing the PivotTable report.

Subtotals & Filters

Subtotals section

Select one of the following:

  • Automatic Uses the default function for the field.

  • None Displays the field without a subtotal.

  • Custom Enables selecting one of the following functions as a subtotal.

Function

Description

Sum

The sum of the values. This is the default function for numeric values.

Count

The number of values. The Count summary function works the same as the COUNTA worksheet function. Count is the default function for values other than numbers.

Average

The average of the values.

Max

The largest value.

Min

The smallest value.

Product

The product of the values.

Count Nums

The number of values that are numbers. The Count Nums summary function works the same as the COUNT worksheet function.

StDev

An estimate of the standard deviation of a population, where the sample is a subset of the entire population.

StDevp

The standard deviation of a population, where the population is all of the values to be summarized.

Var

An estimate of the variance of a population, where the sample is a subset of the entire population.

Varp

The variance of a population, where the population is all of the values to be summarized.

  • Note: You cannot use a custom function with an OLAP data source.

Filter section

Include new items in manual filter    Select or clear to include or exclude any new items in the PivotTable report with an applied filter.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×