Swinging Pivot Dimensions

The swing feature allows you to re-orient the axes of a pivot table and view your data in new ways. When you “swing” a dimension, you can move it up, down or to the opposite axis. This feature is a powerful tool that makes pivot table reporting more powerful than a common spreadsheet.

Note:

You can swing pivot dimensions by moving items within and between data layout panes.

  To swing a dimensional label:

  1. Select a dimensional label and choose Swing on the shortcut menu.

  2. Select a direction.

    Valid swing positions are:

    • Vertical

    • Horizontal

    • Up

    • Down

    • Left

    • Right

    • Before

    • After

      If you select the “before” swing positions, you must choose the dimension label before which you wish to place the selected label. This behavior applies to the “after” selection as well.