With the Columns Settings you can select the columns you want to display, arrange them in the desired order, and customize each column to the smallest detail.

Note: column customizations apply to the current instance of the panel only, and are stored in the Workspace or layout. This means that they will be lost if you close the panel, and that you will not be able to use your customizations in a future session unless you save the Workspace or layout.

To open the Columns Settings, right-click anywhere in the table and select Settings. The Settings dialog box is displayed as follows:

Displaying and Hiding Columns

The Columns box on the left lists the columns available in the panel. Visible columns have checkmarks against them. To display or hide a column, click the checkbox to place or uncheck a checkmark.

Reordering Columns

To reorder columns, click on the column you want to reorder, drag it anywhere you need holding down the left mouse button. 

Configuring Each Column

To configure settings for a particular column:

1. Select a column in the Columns box. The Preview box shows how the column looks on the screen.
2. The Column settings area on the right displays all settings available for the selected column, arranged in categories. To expand a collapsed category, click the "+" sign.
3. Select a setting. The cell containing the value becomes editable, and the box below the Column settings area displays a short description of the setting.

When a setting is set to (none) or NotSet, the column uses the setting that applies to the entire table. For details on how to change settings for the entire table, see Customizing Tables.

You can select multiple columns simultaneously and configure common settings for them all at once. To select more than one column, hold down the Ctrl key while clicking the columns. To select a range, hold down the Shift key and click the first and last columns in the range.

To close the Settings dialog box and apply the changes to the table, click the OK button.

General

The General category lists the following miscellaneous settings:

• Header - the text to display in the column header. To rename the column, type in the new text.
• Resizable - when set to True, the column width can be changed manually. Click the down arrow and select the new setting from the list.
• Font - the font for column values. To change the font, click the "..." button; in the Font dialog box, select the font, style, size and effects, then click OK.
• View mode - applies to numeric columns only. It specifies whether the value will be shown as a numeric value (Value), a horizontal bar (Bar), or both (Bar & value) or a chart (Graphic).
• Bar type - is only available when Bar or Bar & value is selected for View mode. When set to Absolute, the highest value in the column is represented by a bar spanning the entire column width, and smaller values are represented by proportionally shorter bars. When set to Relative, you need to provide a value that will correspond to the full-length bar.
• Relative - the numeric value represents the full-length bar. It is only available when Relative is selected for Bar type. Type in the value.
• Coloring mode - applies to dynamic numeric columns only. When set to None, the cells use a static background color. When set to By difference, the cells are highlighted with distinct colors based on the difference from the previous value. When set to By sign, the highlight color depends on whether the value is negative or positive. Click the down arrow and select the new setting from the list.
• Alignment - specifies how the contents are aligned in the cells. Click the down arrow and select the new setting from the list.
• Wrap mode - when set to True, long cell contents are wrapped; otherwise, the portion of the contents that does not fit within the cell is hidden. Click the down arrow and select the new setting from the list.
• Allow grouping - when set to True, you can group table entries by this column. Click the down arrow and select the new setting from the list.

Colors

The Colors category lets you choose the colors of cells:

• Background color - the static cell background color. This setting only applies when Coloring mode is set to None. To select a new color, click the down arrow. In the list that opens, select one of the tabs (Custom, Web, or System), and click the color you want.
• Foreground color - the static cell foreground color (text color). This setting only applies when Coloring mode is set to None. To select a new color, click the down arrow. In the list that opens, select one of the tabs (Custom, Web, or System), and click the color you want.
• Selection backcolor - the background color for selected cells. To select a new color, click the down arrow. In the list that opens, select one of the tabs (Custom, Web, or System), and click the color you want.
• Selection forecolor - the foreground color (text color) for selected cells. To select a new color, click the down arrow. In the list that opens, select one of the tabs (Custom, Web, or System), and click the color you want.

Header 

The Header category contains the settings that define the appearance of the column header:

• Font - the header text font. To change the font, click the "..." button; in the Font dialog box, select the font, style, size and effects, then click OK.
• Alignment - specifies how the header text is aligned in the cell. Click the down arrow and select the new setting from the list.
• Background color - the header cell background color. To select a new color, click the down arrow. In the list that opens, select one of the tabs (Custom, Web, or System), and click the color you want.
• Foreground color - the header cell foreground color (text color). To select a new color, click the down arrow. In the list that opens, select one of the tabs (Custom, Web, or System), and click the color you want.

Press Create custom column to create a  custom column with the  specified formula calculation .