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:
- On the Dimensions view, select
the row or column heading representing the dimension you want to pivot.
- 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.