---
schema_version: "1"
id: 171d5cbddd06d5742d870d44e498a75a7c3c30be94b922c9fefd113016b1d79e
title: Show Tabular Information with a Lightning Table
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/dashboards_tables_group_measure_data.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.dashboards_tables_group_measure_data.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 6a06aafc93f42993513a206fd6915cb61673382dfa17eb0548ca6bb9ef2013d3
description: Show up to 200 records and 10 columns and from any field in a source report’s report type. After grouping data in a Lightning table, you can add measures (sum, average, minimum, and maximum) to the grouped data. If a Lightning table's source report has a summary formula column, then you can show it on the Lightning table.
products:
  - Cross Cloud
release: "264"
---
# Show Tabular Information with a Lightning Table

Show up to 200 records and 10 columns and from any field in a source report’s report type. After grouping data in a Lightning table, you can add measures (sum, average, minimum, and maximum) to the grouped data. If a Lightning table's source report has a summary formula column, then you can show it on the Lightning table.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Essentials</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d39114e56">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">To create dashboards:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">Run Reports AND Create and Customize Dashboards</td>
          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">To edit and delete dashboards that you created:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">Run Reports AND Create and Customize Dashboards</td>
          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">To edit and delete dashboards that you created in public folders:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">Edit My Dashboards</td>
          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">To edit and delete dashboards that you didn’t create in public folders:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">Manage Dashboards in Public Folders</td>
          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">To create, edit, and delete dynamic dashboards:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d39114e56 ">Manage Dynamic Dashboards</td>
          </tr>
        </tbody>
      </table>

Ungrouped Lightning tables display detail columns, but not measure or formula columns. Grouped Lightning tables display measure and formula columns, but not detail columns.

Detail columns show per-record information about each individual record. The available fields in a Lightning dashboard table come from the source report’s report type. You can show fields as detail columns in Lightning dashboard tables that aren’t included as columns in the source report.

Measure columns display either the sum, average, maximum, or minimum value of grouped records. Because measure columns are the result of mathematics, they're always based on numeric fields.

Formula columns let you show a summary formula column from the Lightning table's source report on the Lightning table. If a source report's summary formula column is evaluated at **All Summary Levels** or **Grand Total Only**, it's compatible with all Lightning tables. If a summary formula column is evaluated at **Specific Groups**, group data in the Lightning table the same way as the source report to show the formula column.

Reports support up to four groups, but Lightning tables support two groups. So, you can't add a formula column based on the third or fourth grouping of a report. Lightning tables with source reports grouped by both rows and columns only support formula columns based on the report's first-level row and column groupings.

To add a Lightning table to a dashboard, or to edit one:

1. Create or edit a dashboard.
2. Add or edit a widget. In the Edit Component window, click **![Lightning Table icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_chart_icon_table_lightning.png)**.
3. Choose which columns to add.
4. Select a field to group by.
    
    You can group the table by any field from the source report type. Group by a field even if it isn’t part of the report.
    
    After grouping, detail columns disappear and measure columns appear. To display record-level detail columns again, ungroup the table by clicking **X** or **![Remove all columns icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_button_remove.png)**.
5. To add a measure or formula column, choose a field from **Add measure column...**. After adding a measure column, click it and choose up to four measures: **Sum**, **Average**, **Max**, or **Min**. You can't add measures to formula columns.
    
    Add up to 9 measure and formula columns. Remember, you can only measure numeric fields, so date, text, picklist, and Boolean fields aren’t available.
    
    Formula columns are listed before measure columns. Formula columns are identifiable by the formula icon that appears before their name (![Formula column icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_icon_dashboards_formula_column.png)).
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_note.png)
    
    Note
    
    - The default measure column is record count. You can’t remove record count, but after adding another measure column, you can hide it by clicking the eye icon (**![Hide a column icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_icon_dashboards_eye_closed.png)**).
    - Lightning table dashboard widgets don't support unique counts.
6. When satisfied with the Lightning table, click **Add** or **Update**.
7. To save the dashboard, click **Save**.

For example, as seen on the left-hand side of this Sales Overview dashboard, you can use a Lightning table to list details about individual opportunity records. The right-hand Lightning table, grouped by stage, provides a handy reference of key metrics like average probability and sum of amount. The right-most column is a formula column, showing percent of total.

![A Lightning table showing one widget with detail rows on the left and another with groups and measure columns on the right](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_dashboards_tables_grouped.png)

- **[Show Subtotals on First-Level Groups in Lightning Tables](https://help.salesforce.com/s/articleView?id=analytics.dashboards_tables_subtotals.htm&release=264.0.0&type=5)**  
    Lightning tables are a powerful tool for summarizing data on a dashboard. Second-level groups automatically show subtotals for each measure column. Show subtotals to add subtotals for each measure column to first-level groups.