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, Oracle Smart View for Office 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.

Note:

When the Use Excel Formatting option is selected (as described in Using 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.

To pivot a dimension or member:

1. Select a dimension or member.
2. From the data source ribbon, click Pivot.

   Alternatively, you can drag a dimension from the row or column and drop it on the target row or column.

   Row dimensions are pivoted to the topmost column dimension.

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

Note:

You pivot members by selecting them from the POV, as described in Selecting Members from the POV Toolbar.