Pinterest Pixel

Filter by Values – Between

Pivot Tables do not just aggregate data, but also offer a lot of filtering options. One of... read more

Download Excel Workbook
Bryan
Posted on

Overview

Filter by Values - Between

Pivot Tables do not just aggregate data, but also offer a lot of filtering options. One of these is filtering based on a column of values. I will show you quickly the different filter by values options and it is very straightforward to use!

 

Exercise Workbook:

download excel workbookFilter-by-Values.xlsx


This is our current Pivot Table setup. We will be filtering the Sum of Sales amounts.

Filter by Labels - Text

 

Example 1: Filter by Values – Between

STEP 1: Click on the Row Label filter button in the Pivot Table.

Filter by Values - Between

STEP 2: Select Value Filters.

You will see that we have a lot of filtering options. Let us try out – Between

Filter by Labels - Text

STEP 3: Type in between 100000 and 200000. You can see that the Value Filter will be applied to the Sum of SALES.

Click OK

Filter by Labels - Text

Now we have the filtering applied in a flash! The Sum of SALES values now displays the ones between 100,000 and 200,000.

See also  Printing a Pivot Chart

Filter by Labels - Text

 

Example 2: Filter by Values – Not Between

STEP 1: Click on the Row Label filter button in the Pivot Table.

Filter by Values - Between

STEP 2: Select Value Filters.

You will see that we have a lot of filtering options. Let us try out – Not Between

Filter by Values - Between

STEP 3: Type in between 2000 and 600000. You can see that the Value Filter will be applied to the Sum of SALES.

Click OK

Filter by Values - Between

Now we have the filtering applied in a flash! The Sum of SALES values now displays the dates where the sum of sales is not between 20,000 and 600,000.

Filter by Values - Between

 

Following the steps mentioned above, you can easily filter the Pivot Table by values to get data between or not between a specific range. You can also use Pivot Table to filter Top/Bottom items by value or percentage, etc.

Click here to learn all about Pivot Tables.

 

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

See also  Generate Random Numbers: 2 Quick and Practical Ways in Excel

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Filter by Values - Between | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

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!