Data Analysis and Reporting with Intelligence Clients

Working with Table Columns

The following table lists some common formatting options for table columns:

Formatting Options for Table Columns 

---

Remove Column	To remove a selected column from the table (and Outliner), click Remove Column on the shortcut menu. This option is available for detail and fact columns. If an item is removed from the Contents pane, it is removed from the Outliner and the data set entirely. Use caution when removing items since computed items may draw data values from the deleted item and other sections built from the Table section.
Select Column	To select a column, click anywhere inside the column.
Size Column Width	By default, Table columns evenly and without regard to the length of data values. Numeric data that does not fit is replaced with pound signs (#). To auto-size a column so that values display within the column, click the column and choose FormatColumnAuto-Size Width. If you want narrow or uniform columns to display values without truncation, wrap the text with each column item. To apply the standard width to a column, click the column and choose FormatColumnStandard Width. To resize a column manually, click the column, place the cursor over the right edge of the column, and drag the right border to a new position
Modify Column	To modify a computed column or a grouped column, select the column and choose TableModify Column.
Hide/Show a Column	To hide a column, select the column and click Hide Column on either the shortcut menu or the Table menu. To unhide a column, click anywhere within the Contents pane and click Unhide Column on the shortcut menu, or choose TableUnhide Column. When the Unhide Column dialog box appears, select the desired column and click OK.
Size Titles	To apply a custom height to a title, drag the bottom edge of a title row to the new position. To apply the standard height to a title row, choose FormatRowStandard Height.
Suppress Duplicates	To suppress duplicate values for a column, select the column and click Suppress Duplicates on either the shortcut menu or the Format menu. Use this feature to display only the first instance in the column of a duplicate value when individual database records include redundant information. This feature is especially useful if records are associated with the same date, location or customer, and is available for detail and fact column selections.
Wrap Text	To wrap text within a column, select the column and click Text Wrap on either the shortcut menu or the Format menu. Text wrap is available for detail and fact columns.
Group Columns	To merge dimension labels into new groupings and aggregate the associated data, click Add Grouping Columns on the Table menu or the shortcut menu.
Sort Ascending	To sort column values in ascending order, click Sort Ascending on the Table menu, shortcut menu, or standard toolbar.
Sort Descending	To sort column values in descending order, click Sort Descending on the Table menu, shortcut menu, or standard toolbar.
Move Column	To move a column, click the column in the Contents pane and drag it to a new position. The corresponding Outliner line item shifts to reflect the change.

---