For the latest version of JMP Help, visit JMP.com/help.


Basic Analysis > Tabulate > Tabulate Platform Options > Right-Click Menu for Columns
Publication date: 05/05/2023

Right-Click Menu for Columns

In the Tabulate report table, right-click a column to see the following options:

Delete

Deletes the selected column.

Pack Columns

(Available only when you right-click on a statistic column.) Contains options for consolidating statistical columns in the table for a more compact display. See Example of Packing Columns.

Pack

Consolidates the selected statistical columns into a single column.

Unpack

Separates the selected statistics into separate columns.

Template

Enables you to define the display format of the consolidated statistics. The leftmost selected column when you select Pack is designated as ^FIRST, and the rest of the selected columns are designated as ^OTHERS. You can also choose a delimiter to separate the list of statistics that appear inside the parentheses.

Use as Grouping column

Changes the analysis column to a grouping column.

Use as Analysis column

Changes the grouping column to an analysis column.

Change Item Label

(Appears only for separate or nested columns.) Enter a new label.

Combine Tables (Columns by Categories)

(Appears only for separate or nested columns.) Combines separate or nested columns. See Example of Combining Columns into a Single Table.

Nest Grouping Columns

Nests grouping columns vertically or horizontally.

Separate Tables

(Appears only for combined tables.) Creates a separate table for each column.

Remove Column Label

Removes the column name from the column table.

Restore Column Label

Restores a hidden column name to the column table.

Order By Count

Orders the levels of a grouping column by the count of each level, from most to least. This option can also be used to override the setting of the Order by count of grouping columns option for a particular grouping column.

Stack Grouping Columns

(Available only when there are multiple grouping columns.) Specifies that the values of the nested grouping columns appear in a consolidated format to conserve horizontal space in the table. The values of the nested grouping columns are indented to show the hierarchy of the grouping columns. See Example of Stacking Grouping Columns.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).