Reorder columns

ADVANCED TOOLS

To reorder a column, click the column header and drag the column to the desired position. The Visualization panel reflects the new column order after you click Run. 

By default, columns are organized in the following order: 

• Dimensions 

• Dimension table calculations 

• Measures 

• Measure table calculations 

• Row totals 

For the most part, you can reorder columns within each field type but cannot move them out of their field type section. For example, you can rearrange dimension table calculations among themselves, but you can't place a dimension table calculation in between two measures. 

One exception, however, is that you can use the arrow next to the row totals checkbox on the Data tab to move the row total column from the far right of the data table to just after the dimension table calculations. 

You can reorder columns under a pivoted dimension, but you can change the order of pivoted dimensions only by changing the sort order, not by manual reordering.