---
schema_version: "1"
id: 9f6cea076403ecb12b56e09478769b50649680fd8e3fe2e8cf392f4ac859b168
title: Categorize Data with Bucket Columns
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_bucketing_overview.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_overview.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 55d4047f63a43692a06cbc8e7be50821d92cef6b520f7c0d0dbdb8bf4ad1f4cd
description: Quickly categorize report records without creating a formula or a custom field by bucketing them. When you create a bucket column, you define multiple categories (buckets) used to group report values. Like any other column in your report, you can sort, filter, and group by bucket columns.
products:
  - Cross Cloud
release: "264"
---
# Categorize Data with Bucket Columns

Quickly categorize report records without creating a formula or a custom field by bucketing them. When you create a bucket column, you define multiple categories (buckets) used to group report values. Like any other column in your report, you can sort, filter, and group by bucket columns.

### 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: Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Enhanced Folder Sharing</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="d64127e79">User Permissions Needed</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d64127e79 ">To add, edit, or delete a bucket column in private reports:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d64127e79 ">
            <dl>

              <dt style="font-weight:bold;padding-top:.25rem;">Enhanced Folder Sharing</dt>

              <dd style="padding-left:1.5rem;padding-bottom:.5rem;">Create and Customize Reports </dd>

            </dl>
          </td>

        </tr>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d64127e79 ">To add, edit, or delete a bucket column in public and private reports:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d64127e79 ">
            <dl>

              <dt style="font-weight:bold;padding-top:.25rem;">Enhanced Folder Sharing</dt>

              <dd style="padding-left:1.5rem;padding-bottom:.5rem;">
                <p style="margin-bottom:0;">Report Builder OR Report Builder (Lightning Experience)</p>
              </dd>

            </dl>
          </td>

        </tr>
      </tbody>
    </table>

For example, get a view of your accounts based on how many employees they have. Create a bucket column named Size based on the \# Employees field. Then, create buckets that group records into Small, Medium, and Large ranges that you define. Small includes accounts with 5,000 or less employees. Medium includes accounts with 5,000 to 10,000 employees. Large includes accounts with more than 10,000 employees. Now you can sort, filter, or group records based on how they’re grouped in buckets. If one account grows or shrinks, it automatically switches buckets.

![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 Consider a report with custom type and object for which you create a bucket column with a total of more than 1000 characters across the bucket values. It’s possible for the buckets not to appear when you group by columns in dashboards that use the report.

1. **[Add a Bucket Column](https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_adding.htm&release=264.0.0&type=5)**  
    Create a bucket column while editing a report.
2. **[Edit a Bucket Column](https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_editing.htm&release=264.0.0&type=5)**  
    When it’s time to add, remove, or change buckets in a bucket column, edit it.
3. **[Delete a Bucket Column](https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_delete.htm&release=264.0.0&type=5)**  
    When you no longer need a bucket column, delete it.