Right-Click Menu Options

This section describes the options available in the right-click menu when working with tables.

The menu options are slightly different depending on whether you right-click on the table header, the row/column/wafer axes, the table data area, or the footnote/table footer area.

Table Header/Footer Right-Click Menu

Option	Select To...
Font	Select a different font for the table header/footer.
Alignment	Change the horizontal alignment of the text in the table header/footer. You can choose from Left, Centre and Right. You can also select the Use As Default option to save the setting for the next time you create a table.
Assign Annotations	Manage annotations. See Annotations for more information.
Filter Annotation Footnotes	Filter the annotations so that only annotations relating to items currently in the table display in the footnote. If this option is not selected then all the annotations display in the footnote regardless of whether the items they refer to are currently part of the table.
Meta-Information	Create or view table metadata. See Metadata and Multilingual Tables for more information.

Column/Row/Wafer Right-Click Menu

Option Select To...

Drill Navigate down or up through the hierarchy (only available for hierarchical fields). See Navigate Hierarchies (Drill Down, Drill Up) for more information.

Meta-Information Create or view metadata for the field or value. See Metadata and Multilingual Tables for more information.

Derivations

Manage derivations. See Derivations for more information.

Add Field Derivation	Create a field derivation. See Create a Derivation.
Add Blank Field Items	Add a blank field item. See Add a Blank Row or Column to a Table.
Field Reference Item	Make this the reference item for this field. See Field and Axis Reference Items.
Add Axis Derivation	Create an axis derivation. See Create a Derivation.
Add Blank Axis Items	Add a blank axis item. See Add a Blank Row or Column to a Table.
Add External Axis Items	Add an external axis item. See Add External Axis Item.
Axis Reference Item	Make this the reference item for this axis. See Field and Axis Reference Items.
Scroll to Axis Reference Item	Scroll the table to the axis reference item in this axis. This option can be useful if the table contains large amounts of data. Unless you have specifically selected a different item using the Axis Reference Item menu option, the last item in the column, row or wafer will be the axis reference item.
Edit	Edit the selected derivation.
Delete	Delete the selected derivation.
Calculate First	Change the order of evaluation for the selected derivation so that it is calculated first, before all other derivations in this table.
Calculate Last	Change the order of evaluation for the selected derivation so that it is calculated last, after all other derivations in this table.

Sort Sort the row, column or wafer based on the data values. See Sort Tables for more information.

Sort Label Sort the row, column or wafer based on the field labels. See Sort Tables for more information.

Item Font Change the font for the selected item.

Field Font Change the font for the selected field.

Spanner Label

Show or hide the field name on the row, column or wafer.

By default, for concatenated fields, this displays a single label describing each field, for example:

There is an optional configuration setting (ConcatenatedSpanner) that you can add to one of the SuperCROSS configuration files that changes the behaviour of spanner labels. When you turn on this feature, two additional menu options become available, allowing you to choose between Spanner Label > Concatenated (equivalent to the above behaviour) and Spanner Label > Individual, which adds an individual label for each concatenated field:

Format

Apply formatting:

Power of Ten	Display axis items in power of tens, for example tens, thousands, etc. The default is 0, which represents units.
Decimal Places	Set the number of decimal places for the selected column, row or wafer. Acceptable values are between -9 and 9 inclusive (use negative values to apply rounding). This setting will not apply if your table is showing grand total percentages. The decimal places for grand total percentages are controlled by the `OtherDataDecimalPlace` setting in the super.ini configuration file.
Alignment	Change the horizontal or vertical alignment of the text.
Column Width	Change the column width.
Row Height	Change the row height.

Where available, you can use the Extent of Change options to apply the change to:

Only the row/column you clicked on.
All selected rows/columns.
All rows/columns.

Page Break

Insert or remove a page break for use when printing the table. By default SuperCROSS will create the page breaks automatically.

Before

Insert a forced page break before this row. The page break displays as a dashed line on the table.

Logical

Insert a logical page break. You can choose from the following options:

Field Level - Sets the field level where page breaks should be avoided.
Orphan - Sets the lowest number of items to leave alone on a single page.

Assign Annotations

Annotate Selected Field	Manage annotations for the field you clicked on. See Annotations for more information.
Annotate Selected Field Value	Manage annotations for the individual field value you clicked on. See Annotations for more information.

Hide

Hide axis items or field items.

Axis Item	Hide the axis item you clicked on.
Axis Selection	Hide the axis item(s) containing the currently selected cell(s).
Field Item	Hide the field item you clicked on.
Field Item Selection	Hide the field item(s) containing the currently selected cell(s).

Reveal

Reveal previously hidden axis or field items.

Axis Items	Show axis items that have been hidden on the axis you clicked on.
Field Items	Show hidden field items.

Suppress Intersection

Activate or deactivate the Suppress Intersection feature on the selected column, wafer or row. If this feature is activated on both the row and column for a given cell (or both row and wafer, or wafer and column), that cell will be replaced with a string like N/A to indicate that the intersection of the row and column is suppressed.

Activating Suppress Intersection for a field item in nested fields will result in all instances of the field item being affected.

The string used to replace the cell value is controlled by the Suppress Total String setting. You can configure this by changing the setting in Edit > Options > Data.

Find Value

Search the row, column or wafer.

Select the Search In String option to include partial matches.
Select Match Case to only match the exact case.

Table Data Area Right-Click Menu

Option

Select To...

Data Area Font

Change the font used in the table data area. You can choose from the following options:

First - Use the first font set in the Fonts options (Edit > Fonts).
Row - Use the same font as the row header.
Column - Use the same font as the column header.
Priority - Display column, row or derivation label font headers in the same font as the assigned font selections, overriding the table data font display.

Options

Open the Options window. See Options for more information.

Fonts

Change the table font.

Annotate Cells

Manage cell annotations. See Annotations for more information.

Conceal Cells

Conceal or show the selected cells. See Confidentiality for more information about confidentiality in SuperCROSS.

Conceal Selected Cells	Manually conceal the selected cell or cells.
Reveal Selected Cells	Remove manual concealment from the selected cell or cells.
Apply Rules to Selection	Apply the concealment rules to the currently selected cell or cells.
Apply Rules to All	Apply the concealment rules to all cells.

Field Reference Settings

Bookmark field values.

Suppress Zeros

Suppress rows, columns, or wafers that contain only zeros.

Sort Wafers

Sort the table wafers based on the values in the selected cell on each wafer. See Sort Tables for more information.

Edit Cell

Modify the cell. This option is only available for cells that have been imported or inserted.

Records

Activate Record View.

View Records	Open Record View for the selected cell (only available if the administrator has enabled Record View for this database and you have selected a cell). For more information, see Record View.
View Related Records	Open Related Record View for the selected cell (only available if the administrator has enabled Record View for this database and you have selected a cell). For more information, see Related Record View.
Flag Records	Flag records that meet certain criteria so that you can use them in cross tabulations. For more information, see Flag Records.
Export Records	Export records for the selected cell (only available if the administrator has enabled Record View for this database and you have selected a cell). For more information, see Export Records.
Segmentation	Create a segmentation recode based on the selected cell or cells. For more information, see Segmentation.
Analyse Segment	Create a new table based on the selected cell, so you can further analyse the records that contributed to that cell. For more information, see Segmentation.

See Record View for more information.