A Pivot Table allows you to Group your transactional sales values by any range that you want.  You can then summarize each sales group and see the total sales and the number of transactions that they have produced.  This is useful for pricing analysis.

Group Sales with a Pivot Table | MyExcelOnline

DOWNLOAD WORKBOOK

This is our set of data that we will use:

Group Sales with a Pivot Table | MyExcelOnline

STEP 1: Drop Sales into Rows

Group Sales with a Pivot Table | MyExcelOnline

STEP 2: Right click on your Pivot Table and select Group

Group Sales with a Pivot Table | MyExcelOnline

STEP 3: You can start and end at any value. Click OK

Group Sales with a Pivot Table | MyExcelOnline

STEP 4: Once the groupings are in place, drag Sales into Values twice

Group Sales with a Pivot Table | MyExcelOnline

STEP 5: Right click on the first Count of Sales column and select Summarize Values By > Sum

Group Sales with a Pivot Table | MyExcelOnline

You now have your grouped sales data ready!

Group Sales with a Pivot Table | MyExcelOnline

 

Helpful Resource:

728x90

 

 

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Group Sales with a Pivot Table | MyExcelOnline