--- schema_version: "1" id: 218df46d24c706317478183c3e188088b981465b03b7585bd34cf2c5e2f34f10 title: Add a Bucket Column collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_bucketing_adding.md canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_adding.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 3daa72633430152dbcdb187e5c8a1ec275fac438bcf54687f12c99fdc5f3c4a9 description: Create a bucket column while editing a report. products: - Cross Cloud release: "264" --- # Add a Bucket Column Create a bucket column while editing a report. ### Required Editions

Available in: Salesforce Classic and Lightning Experience

Available in: Enterprise, Performance, Unlimited, and Developer Editions

Available in: Enhanced Folder Sharing

User Permissions Needed
To add, edit, or delete a bucket column in private reports:	Enhanced Folder Sharing Create and Customize Reports
To add, edit, or delete a bucket column in public and private reports:	Enhanced Folder Sharing Report Builder OR Report Builder (Lightning Experience)

1. Edit a report. 2. Find the column you want to bucket in the report preview, then click **![the more actions icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/resources-global/_corporate/images/dropdown.png)** | **Bucket This Column**. Alternatively, from the Columns section, click **![the more actions icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/resources-global/_corporate/images/dropdown.png)** | **Add Bucket Column**. The Edit Bucket Column menu opens. 3. From **Field**, choose a field from the report type. The bucket column is based on the field you choose. If you started bucketing a column in the report preview, then the field is already set. 4. From **Bucket Name**, enter a name for the bucket column. 5. Add buckets and choose values for each bucket. Depending on the data type of the column you’re bucketing, you see different bucket options in the Edit Bucket Column menu. You can bucket 3 data types: numeric, picklist, and text.

Numeric	A numeric bucket helps you sort data that can be described in terms of numbers. Numeric buckets include columns with field types like `currency` (Amount), `number` (Number of Employees), and `percent` (Probability), but not necessarily mixed alphanumeric field types like `auto number`. Alphanumeric values don’t reside on the number line, which means they can’t get numerically evaluated, which prevents them from getting bucketed in a numeric bucket. Alphanumeric values can be included in text buckets. Each numeric bucket includes a range and a name. To gain insight into your deals, use bucketing to group by deal size instead of looking at individual deals. For example, create 3 buckets based on deal size: Small, Medium, and Large. Small holds deals worth $1,000 or less. Medium holds deals worth between $1,000 and $25,000 dollars. Large holds deals worth more than $25,000.
Picklist	A picklist bucket contains items that can be selected from a list. To get a generalized view of your accounts, bucket them by industry. Create buckets with industry names like Manufacturing, Technology, and Media. Then, add accounts into the bucket that best represents their operation.
Text	At first glance, text buckets seem to have the same options as picklist buckets. Values of the text column appear as though they were values in a picklist, and you can add them into buckets in much the same way. Unlike picklist fields, text fields feature the Enter Values button. If you know which value you want to bucket, you can use the Enter Values function to quickly bucket it without searching. Entering values is useful if your report has a large number (such as millions) of values and searching for a value is slow. You can also use this method to enter and bucket values that appear in the report later.

Numeric

A numeric bucket helps you sort data that can be described in terms of numbers. Numeric buckets include columns with field types like currency (Amount), number (Number of Employees), and percent (Probability), but not necessarily mixed alphanumeric field types like auto number. Alphanumeric values don’t reside on the number line, which means they can’t get numerically evaluated, which prevents them from getting bucketed in a numeric bucket. Alphanumeric values can be included in text buckets.

Each numeric bucket includes a range and a name.

To gain insight into your deals, use bucketing to group by deal size instead of looking at individual deals. For example, create 3 buckets based on deal size: Small, Medium, and Large. Small holds deals worth $1,000 or less. Medium holds deals worth between $1,000 and $25,000 dollars. Large holds deals worth more than $25,000.

Picklist

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

To get a generalized view of your accounts, bucket them by industry. Create buckets with industry names like Manufacturing, Technology, and Media. Then, add accounts into the bucket that best represents their operation.

Text

At first glance, text buckets seem to have the same options as picklist buckets. Values of the text column appear as though they were values in a picklist, and you can add them into buckets in much the same way.

Unlike picklist fields, text fields feature the Enter Values button. If you know which value you want to bucket, you can use the Enter Values function to quickly bucket it without searching. Entering values is useful if your report has a large number (such as millions) of values and searching for a value is slow. You can also use this method to enter and bucket values that appear in the report later.

6. To create a numeric or picklist bucket, follow the instructions in [Create a Numeric Bucket](https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_adding.htm&release=264.0.0&type=5) and [Create a Picklist Bucket](https://help.salesforce.com/s/articleView?id=analytics.reports_bucketing_adding.htm&release=264.0.0&type=5). To create a text bucket, use the **Enter Values** button. 7. Click **Apply**. 8. Click **Save**. The bucket column appears in the report preview and in the Columns section. Like any other column in the report, you can sort, filter, and group by the bucket column. To edit the bucket column, find the column in the report preview and click **![the more actions icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/resources-global/_corporate/images/dropdown.png)** | **Edit Bucket Column**. To delete the bucket column, click **![the more actions icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/resources-global/_corporate/images/dropdown.png)** | **Delete Bucket Column**. As you prepare to add bucket columns to your report, take note of these limitations: - Each report can include up to 5 bucket fields. - Each bucket field can contain up to 20 buckets. - Each bucket can contain up to 20 values. - Bucket columns are available for use only in the report where they’re generated. To use a bucket in multiple reports, create the bucket column for each report. Or create a separate formula field for the object that’s dependent on the bucket. - Buckets and bucket fields aren’t available for reports that include external objects. - If a bucket column’s source column has a custom index, and you filter by the bucket column, then the custom index performance gains are lost. - If a bucket column has a filter on it, modifying the values in the buckets removes any filters that refer to the bucket column. - Bucket columns don’t support picklist values that contain a tab character. ## Create a Numeric Bucket 1. To create a numeric bucket, click **Add**. Each numeric bucket consists of a range and a name. 2. From **RANGE**, enter the lower-bound and upper-bound breakpoints for ranges. The first number entered buckets values equal to or less than the number you enter. Each subsequent number you enter buckets values greater than the prior number you enter. The last number entered buckets values greater than the number you enter. 3. From **BUCKET**, enter a name for the bucket. 4. Optionally, to move all empty or null values to the bucket that contains the value zero, select **Treat empty values in the report as zeroes**. If deselected, unbucketed values appear as a dash (-). ## Create a Picklist Bucket 1. To create a picklist bucket, click **Add Bucket**. Then, give the new bucket a name. 2. To put values in a bucket, select the values you want to move, then click **Move To** and select bucket you want to move them into. To move values into a new bucket, click **Move To** | **New Bucket**, enter a name for the new bucket. 3. To take values out of a bucket, click **Move To** | **Unbucketed Values**. Unbucketed values appear in the bucket column as they would in a normal report column. You can put them all into a bucket named Other by enabling **Bucket remaining values as Other**. 4. To rename a bucket, click **![the pencil icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/pencil_lex.png)**. To delete a bucket, click **![the delete 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)**.