Use the Swing feature to swap dimensions between rows and columns from the query. This feature enables you to view your data in new ways, and easily compare the new data to data in the originating table. You swing dimensions by dragging the dimension headers (either column or row) from one position to another using the swing handles. By default swing handles are transparent. They only appear when you select a dimension header. When the swing handle appears, it is shown in white with a light grey handle. Once the selection is off, the handle is transparent again.
To swing a dimension column:
Select a dimension column header (number 1 below) by clicking on the border to the left of the header.
The swing handle (number 2 below) is displayed to the right of the rows. In this example the Scenario dimension header is selected.
Select the swing handle and drag it to the new position (left/bottom or right/top).
In the example, the handle has been swung downward and to the left of the Product dimension:
As a result, the Scenario dimension is positioned to the left of the Product dimension:
To swing a row dimension:
Select an entire dimension row header.
The swing handle is displayed at the bottom of the query:
Select and drag the swing handle to the new position (left/right or right/top).
In this example the handle is swing to the right and upward of the query:
The result of the swing is:
Note that the Product dimension is positioned under the Year dimension.