To quickly switch the rows and columns around, you can use the pivot function.

Note: any filters, sort actions or exception highlighting definitions on any of the columns will be lost when perform a pivot.

To pivot the results

•	On the grid menubar click

Pivoting the results will move all hierarchies on the rows axis to the columns axis and vice versa. If you just want to change what is plotted on the chart series/items, see swapping the row and column mappings topic.