Harmoni gives you a lot of control to build an analysis the way you want it. Use Reorder to move columns or rows in your analysis table.
In this article
1. Reorder Columns and Rows
Reorder allows you to move selected columns and/or rows to a different position in an analysis table.
- Reorder is available under Selection in the modify menu.
- The Reorder option appears in the modify menu when you select the column(s) or row(s) you want to move.
- Use the arrow below the icon to access the different reordering options.
- Selecting a column allows you to move that column (vertical).
- Selecting a row allows you to move that row (horizontal).
- If ranking has been applied to a row or column, reordering will not work.
Reorder is not available when ranking has been used. If you want to change the order of items you first need to remove the ranking.
Reorder Options
- When a column is selected, you can: move to first position, move left, move right, or move to last position.
- When a row is selected, you can: move to the top, move up, move down or move to the bottom.
Once you have moved a column or row:
- The order is retained when saving a view.
- The order applies to Excel and PowerPoint exports.
- The Selector also reflects the order of the items.
- In a nested analysis, moving an element within one nested axis moves the element for all the nested axes.
Reorder Measures
You can reorder individual measures or a selection of measures just as you do with standard axes. If you have standard axes and measures in the same analysis and want some measures above and some below the standard axis, Harmoni creates a new measure group for any measures that are moved.
- Several measures are added to an analysis with standard axes.
- The measures are grouped together in a measure group.
- Reordering the measure, Nights, to the bottom of the analysis, creates a new measure group.
Where to from here?
Learn more about Analysis.