The default two-column table uses the first grouping and summary field from the chart in the source report. If the report has no chart, default columns are based on the first grouping and summary field in the report. To use a tabular report as the source report, Rows to Display must be set for that report.
Available in: Salesforce Classic Available in: Professional, Enterprise, Performance, Unlimited, and Developer Editions Setting Description Sort Rows By Choose a sorting element to determine what element you want displayed first in the horizontal axis of any horizontal chart or the vertical axis of any vertical chart. For a table, choose the sort order for the default two-column table to be ascending or descending by row labels or values. Maximum Values Displayed Set the maximum number of elements to include in the top-level grouping of the horizontal axis of a horizontal chart, vertical axis of a vertical chart, or selected axis of a stacked bar chart. For a table, set the maximum number of rows to include. For example, if you want to list only your top five salespeople, create an opportunity report that lists total opportunity amounts by owner and enter 5 in this field. Show Chatter Photos Display Chatter photos for up to 20 records in a horizontal bar chart component whose source report is grouped by a user or group name field. If there are more than 20 records with photos, record names are shown instead of photos. Set Grouping Display to None to show photos. Set the Drill Down to option to Record Detail Page to take users directly to user profile or group pages when they click photos. Chatter must be enabled for photos to be displayed. Depending on your organization's setup, you may not see photos on tables and charts. Customize Table Click this link to create a custom table. The Maximum Values Displayed field is populated with the value you entered, and the first two columns are prepopulated with the default columns. To customize a table, the source report must be summary or matrix format and contain a chart. Table Columns Specify up to four columns to display in the table. Available columns can be any grouping or summary field used in the chart. Update the report's chart or groupings to make more columns available for the dashboard table. Sort Ascending Sort the custom table in A-to-Z or smallest-to-largest order in a column. You can't sort on second-level groupings. Sort Descending Sort the custom table in Z-to-A or largest-to-smallest order in a column. You can't sort on second-level groupings. Show Total Display the total value for the chart. For a table, include the sum total for number and currency summary fields. Reset Table to Defaults Go back to the default two-column table. Low Range Color Select a color to represent the low range, up to the first breakpoint. Breakpoint 1 The value that separates the low and middle range colors on the dashboard. Middle Range Color Select a color to represent the middle range, between the first and second breakpoints. Breakpoint 2 Breakpoint 2 High Range Color Select a color to represent the high range, beyond the second breakpoint.
The default two-column table uses the first grouping and summary field from the chart in the source report. If the report has no chart, default columns are based on the first grouping and summary field in the report.
To use a tabular report as the source report, Rows to Display must be set for that report.