Data Analysis and Reporting with Intelligence Clients

Table Column Formatting Options

The following table lists the column formatting options available in .

Table Column Formatting Options 

---

Options	Description
Changing the Column Name Heading (Title)	To modify the column title, click Expression on the Section title bar, then select the column title that you want to modify. In the Expression line, type the new title between the quotation marks (“ ”) and click the check mark.
Hide/Show Column Name Heading (Title)	To toggle the display of column titles, choose Column Titles on the shortcut menu. A check mark appears next to Column Titles to indicate that column titles are visible. Choose this option again to clear the check mark and hide column titles from view.
Remove Column	To remove a selected column from the report (and Table Outliner), choose Remove Column on the shortcut menu. This option is available for dimension and fact columns. Items should be removed with caution as computed items may draw data values from the deleted item.
Hide/Show Column Total	To toggle the display of column totals, choose Show Column Totals on the shortcut menu. A check mark appears next to Column Totals to indicate that column totals are visible. Choose this option again to clear the check mark and hide column totals from view. This option is available only for fact columns.
Select Column	Click anywhere inside the column.
Suppress Duplicates	To suppress the duplicate values for a column, select the column and choose FormatSuppress Duplicates. Use this feature if you want 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.
Text Wrap	To wrap text within a column, select the column and choose FormatText Wrap.
Sort Ascending/Descending	To sort column values, click Sort Ascending or Sort Descending on the Table menu, shortcut menu, or standard toolbar.
Reordering Columns	If you want the columns in the table to appear in a different order, drag the item in order of how you want it to appear in the Table Outliner. You can also select the column in the actual report and drag it to a new position in the report.

---