You can create something called ‘Bucket’ field in Salesforce. With Bucket fields you can categorize the records in the report itself and on the fly. You don’t need to create a custom field on the object for this.

For example, let say that if you are creating a report on Opportunity and want to categorize the opportunities in the buckets of ‘small’, ‘medium’ & ‘large’ based on the opportunity amount. You don’t need to define this category as a formula field on the Opportunity object. You can create a bucket field in the report and categorize opportunity records on the fly in report itself.

And then once you have created the bucket field, you can also use this in a formula field in the report. So, if I continue from the example above, now let’s say that I want to calculate what % of these opportunities are small opportunities, what % is medium & what % is large opportunities.

If you were not aware of these capabilities of Salesforce reports, you are in for a pleasant surprise. In this step-by-step guide we will take a look at

  • How to add a bucket field to the report 
  • How to use the bucket field in a formula field

And it won’t take more than 15-20 minutes of your time to understand all this. So let’s dive right in.



To download a PDF copy of the presentation above




check to receive weekly updates on more of such awesome guides





(You'll never be spammed on my watch. And that's a promise)

References & Useful URLs:

Blog Change Log:

  • 27-Apr-2021 – Reviewed & Updated. Added step-by-step guide and option to download the PDF
  • 09-Apr-2014 – 1st Published

Related posts:

  1. How to Report on Objects and Fields Defined in Salesforce
  2. Step By Step Guide To Custom Report Type in Salesforce
  3. Report Builder in Salesforce
  4. Formula to calculate difference between two dates in Salesforce
  5. Changing custom field from ‘Text’ to ‘Picklist’