Skip to end of metadata
Go to start of metadata

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

OptionSelect To...
FontSelect 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 AnnotationsManage annotations. See Annotations - SuperCROSS 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-InformationCreate or view table metadata. See Metadata and Multilingual Tables - SuperCROSS for more information.

Column/Row/Wafer Right-Click Menu

OptionSelect To...
DrillNavigate down or up through the hierarchy (only available for hierarchical fields). See Navigate Hierarchies (Drill Down, Drill Up) - SuperCROSS for more information.
Meta-InformationCreate or view metadata for the field or value. See Metadata and Multilingual Tables - SuperCROSS for more information.
Derivations

Manage derivations. See Derivations - SuperCROSS for more information.

OptionSelect To...
Add Field DerivationCreate a field derivation. See Create a Derivation - SuperCROSS.
Add Blank Field ItemsAdd a blank field item. See Add a Blank Row or Column to a Table - SuperCROSS.
Field Reference ItemMake this the reference item for this field. See Field and Axis Reference Items - SuperCROSS.
Add Axis DerivationCreate an axis derivation. See Create a Derivation - SuperCROSS.
Add Blank Axis ItemsAdd a blank axis item. See Add a Blank Row or Column to a Table - SuperCROSS.
Add External Axis ItemsAdd an external axis item. See Add External Axis Item - SuperCROSS.
Axis Reference ItemMake this the reference item for this axis. See Field and Axis Reference Items - SuperCROSS.
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.

EditEdit the selected derivation.
DeleteDelete the selected derivation.
Calculate FirstChange the order of evaluation for the selected derivation so that it is calculated first, before all other derivations in this table.
Calculate LastChange the order of evaluation for the selected derivation so that it is calculated last, after all other derivations in this table.
SortSort the row, column or wafer based on the data values. See Sort Tables - SuperCROSS for more information.
Sort LabelSort the row, column or wafer based on the field labels. See Sort Tables - SuperCROSS for more information.
Item FontChange the font for the selected item.
Field FontChange 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:

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

AlignmentChange the horizontal or vertical alignment of the text.
Column WidthChange 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.

OptionSelect To...
BeforeInsert 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
OptionSelect To...
Annotate Selected FieldManage annotations for the field you clicked on. See Annotations - SuperCROSS for more information.
Annotate Selected Field ValueManage annotations for the individual field value you clicked on. See Annotations - SuperCROSS for more information.
Hide

Hide axis items or field items.

OptionSelect To...
Axis ItemHide the axis item you clicked on.
Axis SelectionHide the axis item(s) containing the currently selected cell(s).
Field ItemHide the field item you clicked on.
Field Item SelectionHide the field item(s) containing the currently selected cell(s).
Reveal

Reveal previously hidden axis or field items.

OptionSelect To...
Axis ItemsShow axis items that have been hidden on the axis you clicked on.
Field ItemsShow 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

OptionSelect 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.
OptionsOpen the Options window. See Options - SuperCROSS for more information.
FontsChange the table font.
Annotate CellsManage cell annotations. See Annotations - SuperCROSS for more information.
Conceal Cells

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

OptionSelect To...
Conceal Selected CellsManually conceal the selected cell or cells.
Reveal Selected CellsRemove manual concealment from the selected cell or cells.
Apply Rules to SelectionApply the concealment rules to the currently selected cell or cells.
Apply Rules to AllApply the concealment rules to all cells.
Field Reference SettingsBookmark field values.
Suppress ZerosSuppress 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 - SuperCROSS for more information.

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

Activate Record View.

OptionSelect To...
View RecordsOpen 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 - SuperCROSS.
View Related RecordsOpen 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 - SuperCROSS.
Flag RecordsFlag records that meet certain criteria so that you can use them in cross tabulations. For more information, see Flag Records - SuperCROSS.
Export RecordsExport 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 - SuperCROSS.
SegmentationCreate a segmentation recode based on the selected cell or cells. For more information, see Segmentation - SuperCROSS.
Analyse SegmentCreate 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 - SuperCROSS.

See Record View - SuperCROSS for more information.

  • No labels