Show data

To switch to data view, select Edit > Show Data from the tool bar.

In the table, the rows represent your category selection and the columns display series. For single-series charts, only the values that correspond to the listed categories and selected filters are displayed. The data table is similar to Microsoft Pivot Tables. The view contains a horizontal and a vertical hierarchy and several filter hierarchies.

The Show Data mode consists of these sections:

Toolbar

The widget toolbar is located below the widget title.

See Widget toolbar.

Filters

The filter section is located below the widget toolbar. It lists the filter hierarchies and their selected elements.

Example: REGION: All Regions, PRODUCT: All Products, PERIOD: All Periods

See Actions on filters.

Data Table

The table shows data values for the selected columns, rows, and filters. You can adjust the data and perform these actions:

• Click on the hierarchies that are highlighted in blue to see the actions on hierarchies.

  See Actions on axis hierarchies.

• Click on the row headers to see the actions that you can perform on row headers.

  See Actions on row headers.

• Click on the column headers that has gray background to see the corresponding actions.

  See Actions on column headers.

• Click on the data cell that typically displays the values to select from the list of action on data cells.

  See Actions on data cells.