Adding Tables to ResultsUse 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, display column and table headings, apply green bar styling, and enable column sorting. If column sorting is selected, the column headers of the columns that can be sorted have a slightly raised visual appearance. A Table view is always added to the results, as the second view. The grand total for columns with the aggregation rule Average 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. Grand totals do not take filters on metrics into account when aggregating the results. For example, you have a report with the Account Name column and the Number of Opportunities metric, with a filter on Number of Opportunities that is greater than or equal to 10. The grand total ignores the filter on the metric and instead aggregates all the opportunities. NOTE: Changes made to the columns in the Table view (for example column format, column order, sort, formulas and so on) can be seen in the Define Criteria page, and changes in the Define Criteria page can be seen in the Table view. To work with a Table view
To specify paging controls and the number of rows per page, display column and table headings, apply green bar styling, and enable column sorting
|
Published 7/6/2017 | Copyright © 2005, 2017, Oracle. All rights reserved. Legal Notices. |