Filter by Values - Between | MyExcelOnline

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 WORKBOOK


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

Filter by Values - Between | MyExcelOnline

 

Example 1: Filter by Values – Between

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

Filter by Values - Between | MyExcelOnline

STEP 2: Select Value Filters.

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

Filter by Values - Between | MyExcelOnline

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 Values - Between | MyExcelOnline

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

Filter by Values - Between | MyExcelOnline

 

Example 2: Filter by Values – Not Between

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

Filter by Values - Between | MyExcelOnline

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 | MyExcelOnline

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 | MyExcelOnline

 

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.

 

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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn