A table is one of the components that you can add to a Dashboard. It is not that much used, as Dashboards are intended to be “Graphical”. I had a requirement to add a table that displays 3 columns to a dashboard. First, I thought that should be easy, just do the report, then add a table to dashboard with the created report as a source. I was wrong, as it is not that straight forward. Let me explain how I did it:
The table in the dashboard should display the top 10 Closed (Booked) opportunities with these columns: Account Name, Opportunity Name and Amount.
First, I created a standard report with the appropriate filter(s), that had the 3 columns I wanted listed in the dashboard:
Now, Let us try to add this report as a source to a table in a dashboard. Go to the Dashboard, add the Table component, and the Source report. Note the error we get! We need to add groupings in the report in order to be a valid source report to this Dashboard table component.
Now, let us try to add the Grouping and Summary to the report:
- Account Name Group
- Opportunity Name Group
- Summarize by the Amount field (Sum)
We will get the 2 Groupings and the 1 Summary in the source report:
Back in the Dashboard: