Move the field up one position in the area. To rearrange fields, click the field name in one of the areas, and then select one of the following commands: Use to filter the entire report based on the selected item in the report filter. Use to display fields in the legend of the chart. A column lower in position is nested within another column immediately above it. Use to display fields as columns at the top of the report. Use to display fields as an axis in the chart. A row lower in position is nested within another row immediately above it. Use to display fields as rows on the side of the report. You can rearrange existing fields or reposition those fields by using one of the four areas at the bottom of the layout section:
You cannot add the same field more than once in a PivotTable that is based on an OLAP data source. 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.Īnother way to add the same field to the Values area is by using a formula (also called a calculated column) that uses that same field in the formula. 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. However, you can’t move the Values Column label to the Report Filters area. You can even move the Values Column label to the Column Labels area or Row Labels areas. You can use this field to move the field positions up and down within the Values area. When you add two or more fields to the Values area, whether they are copies of the same field or different fields, the Field List automatically adds a Values Column label to the Values area.
0 kommentar(er)
