Print      Open PDF Version of Online Help

Analytics > Designing an Analysis > Step 2: Reviewing Results and Creating Layouts > Adding Tables to Results

Adding Tables to Results

Use the Table view to show results in a standard table. Users can navigate and drill down in the results. You can add a grand total and column totals, specify custom table and column headings, and change the formula or aggregation rule for a column. You can also edit properties for a column to control the appearance and layout of a column and its contents, and specify formatting to apply only if the contents of the column meet certain conditions.

You can also specify paging controls and the number of rows per page, specify whether column and table headings are to be displayed, and apply row styling to the table. When row styling is applied, a green background is used in every alternate row in the table. You can change the color if you wish. Row styling makes the table easier to read.

A Table view is added to the results automatically, as the second view. However, you can delete the Table view if you wish.

The grand total for columns with the Average aggregation rule will differ in the Table and Pivot Table views. In the Table view, the grand total for a column with an Average aggregation rule is calculated from the database (as a sum divided by a count). In the Pivot Table view, the grand total is the average of the rows in the result set.

The following procedure describes how to edit a Table view.

To edit a Table view

1. If the view is not already in the compound layout, then add the view.

   For instructions on adding views, see Adding and Editing Views.

2. In the Results tab of the analysis editor, click the Edit View icon for the Table view.

   The Table view editor opens.

3. In the Layout pane, drag fields and drop them into the drop targets as necessary.
4. To specify totals, perform the following actions:

   NOTE: By default, no totals are specified, and the tooltip for the totals icon is No Totals. When you add a total, the tooltip changes accordingly.

   • To add a grand total, in the Columns and Measures section of the Layout pane, click the totals icon and select the location for the total.
   • To add totals for an individual column, click the totals icon for that column and select the location for the total. Then, click the More Options icon for the column, select Aggregation Rule, and make sure that the Report-Based Total option is selected.

     NOTE: The totals icon is available only for columns that can be totaled by. Typically, this is a column that has repeated values that would be summed for a total. Also, if the option Report-Based Total option is not selected, then the system calculates the total based on the entire result set, before applying any filters to the measures.

5. To edit the properties for a column, or to specify formatting to apply if the contents of the column meet certain conditions, click the More Options icon for the column and select Column Properties.

   The Column Properties dialog box opens, where you can make your selections. For information about formatting columns and adding conditional formatting, see Editing Column Properties.

6. To edit the section properties:
   1. Click the Section Properties icon.
   2. Make your selections for the properties and then click OK.
7. To edit the properties for the table, click the Table View Properties icon in the toolbar.
8. In the Table Properties dialog box, make your selections for the properties, and then click OK.

   You can specify the following:

   • The method to be used to browse data, either scrolling or paging controls.
   • The column heading format and whether the subject area name is included in the column heading.
   • Whether null values are displayed.
   • Whether row styling is used.

     If you want to change the color to be used for the background in the alternate rows, then click the formatting button beside the Row Styling check box and select the color you want.

   • Whether duplicate values are displayed.
   • Whether master-detail linking is used.
9. When you finish making changes, click Done to close the Table view editor.
10. Save the analysis.