This view is designed for just rearranging many fields. This view is designed for just adding and removing many fields. This view is designed for adding and removing fields when you have more than four fields in each area. This is the default view, and it is designed for a small number of fields.įields Section and Areas Section Side-By-Side In the list, select one of the following views: To change the view, click the Field List views button at the top of the PivotTable Field List. The PivotTable Field List has five different views that are designed and optimized for different types of PivotTable tasks. You can move only measures, calculated measures, and Key Performance Indicators (KPIs) to the Values area. You can move only hierarchies, attributes, and named sets to the Row Labels, Column Labels, and Report Filters areas. Click the expand and collapse buttons until you find the fields that you want. Measures In an Online Analytical Processing (OLAP) data source, there are often many fields (or measures) organized in a hierarchy of different dimensions, hierarchies, and levels. If you try to add the same field more than once - for example, to the Row Labels and the Column Labels areas in the layout section - the field is automatically removed from the original area and put in the new area. 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)
