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.
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.