Swap Rows, Columns, and Layers

You can swap rows and columns, rows and layers, or columns and layers to analyze your information differently.

For example, if the rows contain quarters of the fiscal year and the columns contain products, you can swap them so rows contain products, and columns contain quarters. That way, you can track trends over time more easily, particularly in single line or multiline displays.

For example, a report with products in the rows, quarters in the columns, and locations in the layers compares performance by region. If you swap rows and layers, you can see how well each product sold. If you swap columns and layers instead, you can compare quarterly sales figures.

Procedure

From the Explore menu, click Swap, and click Rows and Columns, Rows and Layers, or Columns and Layers.

The names of the items available from the Swap command change depending on the type of display selected. For example, in a pie display, the Rows and Columns command is called Displays and Slices, and the Rows and Layers command is called Displays and Layers.

Results

Tip: To swap rows and columns in Explorer reports, you can also use drag and drop. For example, to swap a row and column, select any row category and drag it to the column area.