Changing the Position of a Column in the Plan Table

You can reorder the columns in a plan table to display them in a more meaningful way according to your requirements.

Note:

The following restrictions apply:

  • When you move the top-level dimension value, the entire group moves with it.
  • You can only reorder values within their group. You cannot move a lower-level dimension value to another group. To achieve this, you must create a new column and copy the cells.
  • If the plan is configured to display measures as columns and the plan contains multiple measures, you can only change the order of the measures within the lowest-level dimension value.

You can change the position of a column by dragging its header and dropping it into a new position. Alternatively, perform the following steps:

  1. Open the plan scenario that contains the column whose position you want to change.
  2. Right-click the header of the column that you want to move.
  3. Depending on the required position, do one of the following:

    • Click Move Column Right to move the column by one position to the right. This is only available if the column is not already in the rightmost position of the group.
    • Click Move Column Left to move the column by one position to the left. This is only available if the column is not already in the leftmost position of the group.
  4. Repeat the previous step until the column reaches the required position.
  5. Click Save to save your changes.