---
schema_version: "1"
id: 7a830a459488a410bdb037f53a880c86009c14df6aafe837a904a9c7206a90b1
title: Edit a Picklist Bucket Field
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_bucketing_picklist.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_picklist.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d347e73c86a97e8f714ec69e11e92ec481102f310feedcb227ebf98a40d97fd2
description: A picklist bucket field contains items that can be selected from a list.
products:
  - Cross Cloud
release: "264"
---
# Edit a Picklist Bucket Field

A picklist bucket field contains items that can be selected from a list.

### 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 and Legacy 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="d11070e78">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d11070e78 ">To add, edit, or delete a bucket column in private reports:</td>

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

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

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


                <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="d11070e78 ">To add, edit, or delete a bucket column in public and private reports:</td>

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

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

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


                <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>

![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 following picklist types can’t be bucketed.

- Record types
- Divisions
- Multi-value picklists
- The Type picklist in Activity reports

In the Edit Bucket Field overlay for a picklist field:

1. For Source Column, select the field you want to bucket.
2. Enter a bucket field name. This appears as the column name in the report.
    
    Since a bucket field is intended to have multiple buckets within it, a good name for a bucket field describes the scope of the buckets. For example, a bucket field named “Priority” could have “High,” “Medium,” and “Low” buckets.
    
    ![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_important.png)
    
    Important Picklist bucket names must include one or more letters or symbols. If a picklist bucket field includes a bucket whose name contains only numbers, the bucket field cannot be saved.
3. To create a bucket, click **New Bucket** and enter a bucket name. Create multiple buckets to group your report records.
4. To find a particular value in the list of values, type the first few characters of its name in the Quick Find box. As you type, items that match your search terms appear in the menu.
5. Select values and drag them into a bucket. Alternatively, select values, click **Move To**, and select a bucket or enter a new bucket name.
    
    While you’re bucketing values, use these functions as needed:
    
    - To show all the values in the report, click **All Values**.
    - To show the values for a particular bucket, click the bucket name.
    - To remove values from a bucket, select the values and drag them to another bucket, or drag them to **Unbucketed Values**.
    
    ![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 You can bucket only active picklist values. Inactive picklist values aren’t shown.
6. To move all unbucketed values into a bucket named “Other”, enable Show unbucketed values as “Other”. If this is disabled, unbucketed values appear in the bucket column with the value name.
7. Click **OK**.

In a report, picklist bucket columns are sorted by the bucket position as shown in the Edit Bucket Field dialog box, followed by “Other” if Show unbucketed values as “Other” is enabled, or the unbucketed picklist item names if Show unbucketed values as “Other” is disabled.

#### See Also

- [Picklist Bucketing Example: Industry Types](https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_picklist_example.htm&release=264.0.0&type=5 "Use a picklist bucket field to sort your accounts by their industry.")