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 the selected derivation.
Delete the selected derivation.
Change the order of evaluation for the selected derivation so that it is calculated first, before all other derivations in this table.
Change the order of evaluation for the selected derivation so that it is calculated last, after all other derivations in this table.
Sort the row, column or wafer based on the data values. See Sort Tables for more information.
Sort the row, column or wafer based on the field labels. See Sort Tables for more information.
Change the font for the selected item.
Change the font for the selected field.
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:
Power of Ten
Display axis items in power of tens, for example tens, thousands, etc. The default is 0, which represents units.
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.
Change the horizontal or vertical alignment of the text.
Change the column width.
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.
Insert or remove a page break for use when printing the table. By default SuperCROSS will create the page breaks automatically.
Insert a forced page break before this row. The page break displays as a dashed line on the table.
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.
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 axis items or field items.
Hide the axis item you clicked on.
Hide the axis item(s) containing the currently selected cell(s).
Hide the field item you clicked on.
Field Item Selection
Hide the field item(s) containing the currently selected cell(s).
Reveal previously hidden axis or field items.
Show axis items that have been hidden on the axis you clicked on.
Show hidden field items.
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.
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
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.
Open the Options window. See Options for more information.
Change the table font.
Manage cell annotations. See Annotations for more information.
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 rows, columns, or wafers that contain only zeros.
Sort the table wafers based on the values in the selected cell on each wafer. See Sort Tables for more information.
Modify the cell. This option is only available for cells that have been imported or inserted.
Activate Record View.
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 that meet certain criteria so that you can use them in cross tabulations. For more information, see Flag 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.
Create a segmentation recode based on the selected cell or cells. For more information, see Segmentation.
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.