Pinterest Pixel

Group by Sales Range in Excel Pivot Tables

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

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.
Group by Sales Range in Excel Pivot Tables | MyExcelOnline Group by Sales Range in Excel Pivot Tables | MyExcelOnline

 

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

Download excel workbookGroup-by-Sales-ranges.xlsx

 

Here is our data table:

Group by Sales Range in Excel Pivot Tables


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

Group by Sales Range in Excel Pivot Tables

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

Group by Sales Range in Excel Pivot Tables

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

STEP 4: Now drag Sales to Values twice

Group by Sales Range in Excel Pivot Tables

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

STEP 6: Select Sum and click OK

Group by Sales Range in Excel Pivot Tables

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

Group by Sales Range in Excel Pivot Tables

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

 

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

If you like this Excel tip, please share it
Group by Sales Range in Excel Pivot Tables | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Refresh External Data Source in Excel Pivot Table

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...