A Bucket Field is a report-only field that categorises values into custom groups without creating a custom formula field on the underlying object. You define the buckets inside the Report Builder, and rows fall into them based on rules you set — perfect for “ad-hoc categorisation”.
Why buckets exist
Imagine you want to report on Opportunity Amount in tiers: “Small (under 10K)”, “Medium (10K-100K)”, “Large (over 100K)”. You could:
- Add a custom formula field on Opportunity — but that’s permanent and per-object
- Hand the rules to a developer — overkill for a report
- Create a bucket field — local to the report, takes one minute
The bucket field wins for one-off or experimental categorisations.
Three flavours of bucket
| Source field type | Bucket rule |
|---|---|
| Picklist | Group multiple picklist values into one bucket (“Hot/Warm/Cold” from a 20-value picklist) |
| Text | Match-by-value bucketing (substrings, exact matches) |
| Number | Numeric ranges with thresholds (“Small under 10K, Medium 10K-100K, Large 100K+“) |
Example: Opportunity Amount bucket
Bucket field name: Deal Size
Range definitions:
Amount < 10,000 → "Small"
Amount >= 10,000 and < 100,000 → "Medium"
Amount >= 100,000 → "Large"Now group your Opportunity report by Deal Size instead of raw Amount, and the report subtotals by tier.
Example: Industry bucket
Bucket field name: Vertical
Bucketed values:
Hardware, Software, Manufacturing → "Industrial / Tech"
Healthcare, Pharma, Biotech → "Life Sciences"
Banking, Financial Services → "Financial"
(Other) → "Other"Building one
- In the Report Builder, click Columns → Add Bucket Column
- Pick the source field (a picklist, text, or numeric field on the report)
- Define the buckets (drag values into groups, or set range thresholds)
- Name the bucket field
- Save the report — bucket lives only on this report
What buckets can and can’t do
| Yes | No | |
|---|---|---|
| Group / pivot by bucket | Yes — Group Rows by the bucket | |
| Filter by bucket | Yes | |
| Use in summary formulas | Yes | |
| Reuse across reports | No — local to the report | |
| Available in Joined reports | No — bucket fields are not supported in Joined | |
| Available in SOQL / Apex | No — it’s a report-builder feature only |
When to promote to a custom field
If you find yourself recreating the same bucket field in 10 reports, that’s the cue to make a custom formula field on the object. The formula field is reusable, available in SOQL, and consistent. Bucket fields are best for one-off and experimental groupings.
Common follow-ups
- Buckets per report? — Up to 5 bucket fields per report.
- Buckets in Joined reports? — Not supported.
- Can I bucket a date field? — Not directly — use the date grouping options (week / month / quarter) instead.
Verified against: Salesforce Help — Bucket Fields. Last reviewed 2026-05-17 for Spring ‘26.