Pivoting

You can pivot a dimension between rows and columns if there are two or more dimensions in the row or column that contains the dimension that you want to pivot. You can also pivot a member; if you do so, the other members in its group are also pivoted.

  To pivot a dimension or member:

  1. Select a dimension or member.

  2. From the data source ribbon, click Pivot.

    Row dimensions are pivoted to the topmost column dimension.

    Column dimensions are pivoted to the leftmost row dimension.

    Note:

    Excel formatting is lost upon pivoting.