Add, delete, or rearrange scorecard rows and columns

In PerformancePoint Dashboard Designer, you can add, delete, or rearrange (transpose) rows and columns in a scorecard.

Note: Before you modify rows or columns in a scorecard, you should update the scorecard to make sure that you have the most recent data.

What do you want to do?

Add rows or columns to a scorecard

Delete rows and columns in a scorecard

Rearrange (transpose) rows and columns in a scorecard

Next steps

Add rows or columns to a scorecard

  1. In the Workspace Browser, click Scorecards.

  2. On the Server or Workspace tab, double-click the scorecard that you want to change.

  3. From the tree in the Details pane, locate the item that you want to use as a row or column header. To add the item as a row or column header, drag it to the scorecard.

      Special notes about rows or columns for aggregation

    The cell values that Dashboard Designer uses to calculate aggregation depend on whether the aggregation item is a row header or a column header.

    To add an aggregation row or column to the scorecard, select the item in the Aggregation node of the Details pane that you want to use as the aggregation header.

    • Aggregation item is a column header     When you add an aggregation item as a scorecard column header, Dashboard Designer includes the metrics adjacent to the aggregation item. Dashboard Designer calculates each metric independently, and adds the metric as a separate column under the aggregation header.

    • Aggregation item is a row header     When you add an aggregation item as a scorecard row header, Dashboard Designer aggregates all rows that appear above the item in the scorecard.

    Note: When you position the pointer on an item that is valid to use as a row header or column header, Dashboard Designer highlights the item. If the item is not valid for use as a header, no highlight appears.

Top of Page

Delete rows and columns in a scorecard

  1. In the Workspace Browser, click Scorecards.

  2. On the Server or Workspace tab, double-click the scorecard that you want to change, and then click the Edit tab.

  3. In the Format section, select Delete All, Delete All Columns, or Delete All Rows.

    Note: You cannot delete just one individual row or column, or just one selected group of rows or columns. You can only delete all rows, delete all columns, or delete all rows and columns.

Top of Page

Rearrange (transpose) rows and columns in a scorecard

  1. In the Workspace Browser, click Scorecards.

  2. On the Server or Workspace tab, double-click the scorecard that you want to change, and then click the Edit tab.

  3. In the Format section, select Pivot to rearrange (transpose) the data from rows into columns or rearrange the data from columns into rows.

Top of Page

Next steps

See all steps that are required to build a scorecard

See how to create a scorecard by using the wizard

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×