Excel2007 the field setting method in the table

  Use the Excel 2007 Field Settings dialog box to control the various formatting, printing, subtotals, and filter settings for fields in a PivotTable report.　　 The

Source name displays the name of the field in the data source. The

Custom name displays the current field name in the PivotTable report, or the source name if no custom name exists.　　 To change the custom name, click the text in the box and edit the name.　　

Layout and printing

Layout section

Show item labels as outlines click this option to display the field items in outline form.

Displays the labels for the next field in the same column (compact form) Select or clear this option to show or hide labels for the next field in the same column or compact form. It toggles between turning on or off compact forms for the selected field.　　 This check box is enabled only if you selected show items as outline.

Displays a subtotal selection at the top of each group or clears this option to show or hide subtotals at the top of each group. 　　 This check box is enabled only if you selected show items as outline.

Display item labels in tabular format Click this option to display the field items in a tabular format.　　 This setting affects only the fields in the row label area.

Insert a blank row after each item Select this option to insert a blank line after each item to provide greater spacing for items such as subtotals. 　　 When this check box is cleared, field items with no blank lines are displayed.　　

Note You can apply character and cell formatting to blank lines, but you cannot enter data in them. 　　

Displays empty data items Select or clear this option to show or hide empty data items.　　

Note this check box is not available for OLAP data sources.　　

Print Section

Insert page breaks after each item Select or clear this option to insert or not insert page breaks after each item when you print the PivotTable report. 　　

Subtotal and filter

Subtotals section

Select one of the following:

Automatic: Use default functions on fields. 　　

None: Displays fields with no subtotals. 　　

Custom: Allows you to select one of the following functions as a subtotal. The

function describes the sum of the

sum value. 　　 It is the default function for numeric values.The number of

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

Average. 　　 The

Max Max value. 　　

min min value. 　　 The product of the

product value. The number of

Count nums numeric values. 　　 The Count Nums summary function works the same way as the Count worksheet function. 　　 The

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

StDevp the standard deviation of the population, where the population is all the values to be summarized. 　　 The estimated value of the

Var population Variance, where the sample is a subset of the entire population. 　　 The

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

Annotation Custom function is not available for OLAP data sources.

Filter Section

include a new item in a manual filter Select or clear this option to include or exclude any new items in the applied filter in an Excel 2007 PivotTable report.