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.