Swap Rows and Columns

You can exchange the positions of categories in rows and columns. For example, a report contains few rows but many columns that exceed the width of the printed page. You swap the rows and columns to fit the report on one page.

You can also exchange the positions of categories within a nested crosstab . For example, you have Products nested within Years but you exchange the positions to see Years nested within Products.

Step to Swap Rows and Columns

• On the PowerPlay Web toolbar, click the Swap Rows and Columns button .

Tip: You can also drag and drop rows and columns to swap them .

Step to Swap Nested Levels

• In the PowerPlay Web display, right-click the level selector area for the nested category, and choose how you want to swap the nested levels:
  • If the nested category is in a column, click either Swap Up or Swap Down.
  • If the nested category is in a row, click either Swap Right or Swap Left.

The positions of the parent category and the nested category are exchanged.

Tip: You can also drag and drop nested levels to swap them .