Worksheets

To create a column for each group. This 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.

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 font color of the text for the entire row.

To change the background color of the entire row.

To display or hide the horizontal border.

To display or hide the vertical border.

To make the header text bold.

To make the header text italic.

To underline the header text.

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 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 selected, click 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.

To display the advanced options for this group.

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.

• Value Code: 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.

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.

To show the prompt for this pivot.

To display values when there is no data. For example:

• To display a year for a Year pivot: Enter 2017.

• To display month values for a specific year in a double pivot (Year, Month): Enter 1;2;3.

• To display a month for another year in addition to the months above: Enter 1;2;3;1[2018].

• To display a description in the column for the second month of year 2017: Enter 2|Your description.