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. 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.
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
Data Table
The table shows data values for the selected columns, rows, and filters. You can adjust the data and perform these actions:
  • Click the hierarchies to see the actions on hierarchies.
  • Click the filter icon in the rows to filter string-type elements.
  • Click the row headers to see the actions that you can perform on row headers.
  • Click the column headers that has gray background to see the corresponding actions.
  • Click the data cell that typically displays the values to select from the list of action on data cells.