Group by Sales Range in Excel Pivot Tables | MyExcelOnline

With Pivot Tables, you can easily group by sales range, then create aggregate data based on your groups. And the best part, it can be done in just a few steps!

 

Here is our data table:

Group by Sales Range in Excel Pivot Tables | MyExcelOnline

 

We want to use Pivot Tables to create a group by sales ranging between 10,000 to 100,000 and then get a count and sum of sales of these ranges. Following the step-by-step tutorial below this result can easily be achieved:

 

Don’t forget to download the Exercise Workbook below and follow along with us:

DOWNLOAD EXCEL WORKBOOK

 


STEP 1: Let us start with an empty Pivot Table. Drag Sales to Rows

Group by Sales Range in Excel Pivot Tables | MyExcelOnline

STEP 2: Right-click on any Sales value and select Group

Group by Sales Range in Excel Pivot Tables | MyExcelOnline

STEP 3: Let us set our group range to 10,000-100,000 with the groupings by 10,000. Click OK.

Group by Sales Range in Excel Pivot Tables | MyExcelOnline

STEP 4: Now drag Sales to Values twice

Group by Sales Range in Excel Pivot Tables | MyExcelOnline

STEP 5: We will get 2 similar columns. We want to have them show the Sum and Count.

Select any one of the columns and pick Value Field Settings

Group by Sales Range in Excel Pivot Tables | MyExcelOnline

STEP 6: Select Sum and click OK

Group by Sales Range in Excel Pivot Tables | MyExcelOnline

Now you are able to gather data based on the grouped sales figures!

group by sales range

You can use this method to group Pivot Table data by sales range, age, price range or any other numerical data!

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Linkedin