Pivoting row or column dimension

On the Dimensions view, pivoting moves a single row or column dimension to another axis. You can pivot a row dimension to move it to the vertical axis as a column dimension, for example. You cannot pivot a page dimension.

To pivot a row or column dimension in dimensional view table, complete the following steps:
  1. On the Dimensions view, select the row or column heading representing the dimension you want to pivot.
  2. Right-click the row or column, and then click Pivot on the pop-up menu. The dimension on the row axis moves to the column axis, or the column axis moves to the row axis, depending on the starting point.

Copyright IBM Corporation 2005, 2006. All Rights Reserved.