Insert blank columns or rows

Insert a blank column or row into an Exploration View to create white space or to add cell-based calculations. You can use the new row or column to insert any Microsoft Excel calculation, such as AVG, MIN, or MAX.

About this task

Depending on the type of data, such as relational or asymmetric you experience very different results. Experiment with different approaches to see what makes sense in your environment.

After you insert a row or column into an Exploration View, the rows or columns are separated into two distinct blocks of items before and after the inserted row or column. If you want to use the Expand level / Collapse level feature, you must do so for each block separately.

Procedure

  1. Right-click a column or row header in the Exploration View where you want to insert a column or row.

    If the Exploration View area expands, make sure that it does not overwrite items.

  2. Click IBM® Planning Analytics > Insert user row/column.

    A blank column or row appears next to or under the selected column or row.

Results

The blank row or column is added to the Exploration View.

You can leave the row or column blank. You can also populate the blank column or row with a Microsoft Excel calculation. For more information, see Create a calculated column or row from scratch.