Summary Tables

What is this Report Type?

Summary Tables are specialized grids that focus on providing high-level aggregated data rather than individual records. They group data by one or more dimensions and present key metrics for each group, often including subtotals and percentages of the total.

Why is it used?

While a standard Data Table shows every row, a Summary Table is used for “management-level” reporting. It condenses thousands of records into a few dozen meaningful rows, allowing users to quickly compare performance across departments, regions, or time periods without getting lost in the weeds.

Key Features & Characteristics

Automated Grouping: Automatically aggregates data based on selected dimensions (e.g., Category or Date).
Pre-Calculated Metrics: Displays sums, averages, or counts for each group by default.
Comparative Analysis: Often includes “Performance vs. Target” or ”% of Total” columns to provide relative context.
Clean Layout: Optimized for readability with clear headers and summary footers.

When to use it (Use Cases)

Departmental Budgeting: Viewing the total budget allocated vs. spent for each department in the company.
Sales Performance: Listing all sales representatives with their total closed deals and average deal size.
Inventory Status: Summarizing total stock value and quantity across different warehouse locations.
Marketing Channel ROI: Comparing the total spend and total conversions for each digital marketing channel.

Real-Time Business Example

Scenario: A regional manager needs a quick weekly update on sales performance across five territories. Visualization: A Summary Table lists the five territories as rows. For each row, it displays “Total Revenue,” “New Customer Count,” and “Average Deal Size.” A final “Grand Total” row at the bottom provides the cumulative performance for the entire region.

Common Metrics Displayed

Group Aggregates: Total revenue or count per category.
Average Metrics: Mean values for specifically selected metrics.
Comparative Percentages: How much each group contributes to the overall total.

User Interactions

Filters: Dynamically update the summary by applying dashboard-level filters (e.g., changing the time period).
Drill-downs: Clicking a group name in the table can take the user to a more detailed Data Table showing the specific records that make up that group’s summary.
Exports: Export the summarized view directly to CSV or Excel for internal reporting.

Creation Steps

Select Summary Table as the report type.
Group By: Drag the dimension field for row grouping (e.g., Territory).
Metrics: Add aggregated values (e.g., Sum of Revenue, Avg Deal Size).