Pivoting Dimensions and Members between Rows and Columns

You can pivot a dimension or a member between rows and columns in an ad hoc grid.

Pivoting dimensions and members between rows and columns in a grid helps you look at data from different perspectives, make side-by-side comparisons, and identify patterns in order to interpret the data better. In an ad hoc grid, you can view the POV in the column headers of the top most row in the grid, and also by opening the POV panel.

Pivoting Dimensions and Members between Rows and Columns

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.

  4. Optional: To rearrange or move the position of the pivoted dimension, see Rearranging Dimensions on the Grid.
  5. Optional: To pivot a row or column dimension to POV, see Pivoting Dimensions and Members between Grid and POV.