Pivoting Dimensions between Rows and Columns

You can pivot a dimension or members between rows and columns.

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.

When you pivot a member, the other members in its dimension are also pivoted.

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.

To pivot a dimension or member from a row to a column or from a column to a row:

1. Select a dimension or member in the grid.

2. From the provider ad hoc ribbon, in the Analysis section, click the arrow under Pivot, and then select Pivot.

3. Observe the change in the grid.

   • Row dimensions are pivoted to the top most column dimension.

   • Column dimensions are pivoted to the left most row dimension.

Note:

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.