Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can focus on specific rows (In a financial statement, you can select:

  • Rows, such as a range of accounts and/or groups

) in a financial statement. When you focus on the rows, you move into the Analytics grid, where you can analyze the data further, such as drill down into the transactions.

Select the row(s):

To select one row, click the Select (blue star) button that displays when you
  • .

  • Snippets of data, such as a list of account names and their values.

You can then quickly view the average, count and sum (where applicable) of the selected data or copy the selected data for use elsewhere, such as a Microsoft Excel worksheet. In the case of selected rows, you can focus on the data in the Analytics grid.

Select rows

To display the Select (blue star) button, hover over the left side of

the

a row. When you select a row

is selected

, it turns blue.

 

  • To select one row: Click the Select (blue star) button.

  • To select multiple consecutive

rows, expand the
  • rows,

then
  • either:

Select
    • Click the first

row
    • Select (blue star) button, hold and drag your mouse up or down

over
    • the other rows

you want to include in your selection
    • , then release

the Shift key
    • your mouse.

    • Select the first row, hold down the

Ctrl
    • Shift key

and
    • , select the last row

you want to include in your selection
    • , then release the

Ctrl
    • Shift key.

  • To select

a range of
  • multiple, non-consecutive rows

, expand the rows, then select
  • : Select the first row, hold down the Ctrl key

and
  • , select the other

rows
  • row(s)

you want to include in your selection
  • , then release the Ctrl key.

  • To select all rows: Click the Select all (blue star) button in the top left corner of the grid, then click Select All.

Deselect rows

When you deselect a row it returns to white.

  • To deselect one or more selected rows, use one of the above selection methods

. The rows return to white color.
  • Click the Focus button to move into the Analytics grid.

  • Image Removed InfoTo return to the high-level summary information, click the Delete button (blue star) on the dimension(s), then click the Summary button.
    • , as applicable.

    • To deselect all selected rows: Click the Selection (blue star) button in the top left corner of the grid, then click Select None.

    Info

    You can click the Reset button to deselect all rows but that action will also reset any other settings you have applied to the grid.

    Select snippets of data

    You can select one or more cells in the grid. Your selection can include a mix of cell contents, such as a code, name or value. When you select a cell it turns blue and information displays at the bottom of the grid (see next section).

    • To select one cell: Click the cell.

    • To select multiple, consecutive cells, either:

      • Click and drag your mouse over the cells.

      • Click the first cell, press and hold the Shift key, click the last cell, then release the Shift key.

    • To select multiple, non-consecutive rows: Select the first cell, hold down the Ctrl key, select the other cell(s), then release the Ctrl key.