Worksheets

To select a global appearance theme for the View. This might change the chosen colors.

To create a column for each group. It is particularly useful before exporting the Worksheet to Excel.

To always display the group column when scrolling right when activated.

To reverse all data in the Worksheet (positives and negatives) for display purpose.

This option is only available when a Pivot is set. The total column can be displayed before (front) or after the Pivot.

This option is only available when a Pivot is set. The Normal Pivot will show all columns (Measures) together, for each Pivot value. The Altered display is when the values of the Pivot are repeated for each column (Measure).

To increase the visibility of the Worksheet's outside border.

To change the column width to display the content of the groups.

When activated, this option changes all of the columns widths.

To open the Group Formatting window (refer to Group Formatting for more details).

To view the entire table in the screen.

To hide the headers.

To add a customized group description. Clicking the Translate button on the right side of the field allows users to add translations for their group description.

To change the headers text color by using the drop-down menu.

To change the headers background color.

To show or hide the borders inside the header.

To make the header text bold.

To make the header text italic.

To underline the header text.

To hide or show the entire row.

To display the entire row at the bottom or before the content of the Worksheet.

To change the layout of the text for the entire row.

To change the layout of the text for the entire row.

To change the thickness of the horizontal border.

To change the thickness of the vertical border.

To add a customized total row description.

To specify an alignment position for the total row. The possible values are left, center and right (right alignment is selected by default).

To make the header text bold.

To make the header text italic.

To underline the header text.

To hide the grid of the worksheet.

To choose the font color for all levels of the grid.

Different background colors can be used for 6 levels of rows (groups). The last level is always used for the content and will also apply to the rest of the groups if more than 5 are used.

When turned on it will display all the vertical lines of the grid content.

When turned on it will display all the horizontal lines of the grid content.

When turned on it automatically refreshes the view upon opening.

To choose a refresh time to apply, in seconds, when auto-refresh is enabled.

To display a prompt where to click and write the Field name in order to display the selection list. Once one or more Fields are chosen, click on OK.

To enter or quit the select mode for this section. When in select mode, click on fields to select them and then these can be deleted with the bin icon or moved up or down together.

To show the Prompt for this Group or Pivot. Refer to Prompts for more details.

To display the advanced options for this group. Refer to Advanced Filters for more details.

To choose ascending or descending order.

To choose a format for the group, as defined in the Data Model (you can choose code, title and description combinations).

Sorting a group column can be done by using three values:

Default: According to the displayed. ValueCode: Based on the group code.

Description: Based on the group description.

To expand the groups up to the current level or collapse all the groups.

To add page breaks between groups in Worksheets and Reports that are exported to PDF format.

To add or select the Column details to show what will be displayed.

The following properties are displayed when a field is selected:

To change the display name for the group (usually already determined by the Data Model).

To change the display name for the column (usually already determined by the Data Model).

To add or select a Pivot.