Row and Column fields You can add a field only once to either the Report Filter, Row Labels, or Column Labels areas, whether the data type is numeric or non-numeric. Value fields If you select a check box only for a numeric field, by default, it is moved to the Values area. To create a field layout, use the following guidelines for moving Value, Name, and Dimension fields from the field section to the four report areas in the layout section. If you don't see the fields that you want to use in the PivotTable Field List, refresh the PivotTable or PivotChart to display any new fields, calculated fields, measures, calculated measures, or dimensions that you have added since the last operation ( PivotTable Tools, Options tab, Data group). You can also click Field List on the Ribbon ( PivotTable Tools, Options tab, Show group for a PivotTable PivotChart Tools, Analyze tab, Show/Hide group for a PivotChart). Right-click the PivotTable, and then click Show Field List. If you close the PivotTable Field List, you can display it again. If you don't see the PivotTable Field List, make sure that you click anywhere in the PivotTable. You can also undock the PivotTable Field List, in which case, you can resize it both vertically and horizontally. You can dock the PivotTable Field List to either side of the Excel window and horizontally resize it.
By default, the PivotTable Field List displays two sections:Ī field section at the top for adding fields to and removing fields from the PivotTableĪ layout section at the bottom for rearranging and repositioning fields When you create a PivotTable, Excel displays the PivotTable Field List so that you can add fields to the PivotTable, rearrange and reposition them as needed, or remove them from the PivotTable.
0 kommentar(er)
