Pivoting Dimensions and Members
Pivoting changes the orientation of the data on the worksheet. You can move dimensions and members between rows and columns and between the grid and the POV.
Pivoting dimensions and members between rows, columns, and POV helps you look at data from different perspectives, make side-by-side comparisons, and identify patterns in order to interpret the data better. You can pivot and rearrange data in the following ways:
- Pivoting Dimensions and Members between Rows and Columns
- Pivoting Dimensions and Members between Grid and POV
- Rearranging Dimensions on the Grid
Guidelines on Pivoting between Rows, Columns, and POV
Consider the following guidelines when pivoting dimensions and members:
- When you pivot between rows and columns, Smart View moves the selected dimension to the outermost row or column on the opposite axis. For example, when you select to pivot a dimension to a row, the system moves the dimension to the top of the grid.
- There must be two or more dimensions, or members from two or more dimensions, in the row or column that contains the dimension that you want to pivot. That is, you cannot pivot the last row dimension or the last column dimension on a grid.
- The grid must always contain at least two dimensions: one row dimension, and one column dimension. When there is only one row dimension and one column dimension on a grid, you must first pivot the replacement dimension on to the grid before you can pivot a dimension out of the grid. For example, if you want to pivot the row dimension out of the grid, then you must first pivot the replacement row dimension on to the grid, and then pivot the required row dimension out of the grid.
- When you pivot a member, the other members in its dimension are also pivoted.
- You can leave any number of dimensions in the POV.
- After pivoting the last dimension from the POV to the grid, the POV panel is hidden. You can always reopen the POV panel to display it again.
- You can pivot members by selecting them from the POV, as described in Selecting Members from a Point of View Dimension.
- When you use Excel formatting, member and numeric formats may unexpectedly change after pivot operations. For example, member names may be centered and numeric values may be left-justified. You can reset the grid to the proper format using the Excel formatting options. See Formatting Ad Hoc Grids.