Table

A data table is a spreadsheet built on a data source.

To show or hide table, press or release the Table button on the View ribbon tab.

Data Table Structure

A data table consists of several main elements, each of them has its own settings.

Table elements:

• Corner. The top left cell of the table that enables the user to show dimension names in rows and columns.

• Sidehead. The table element that shows names of dimension elements located in rows.

• Heading. The table element that shows names of dimension elements located in columns.

• Data. The table element that consists of data cells.

To apply table settings to one of the table elements, select it.

NOTE. On selecting a table element the Table group of tabs on the side panel is renamed according to the selected element: if table heading or sidehead is selected, the tab is named Heading, when the corner is selected, it is named Corner, and when the data is selected, the tab is named Data.

Setting Up Data Table

General parameters of table

Set up table appearance

Work with table data

Work with table hyperlinks

Work with table dimensions

Table data analysis

Calculate totals

See also:

General Parameters of Table