We must use “ Clear filter from Country ” above Label filters in figure 6 if we do not want values Greater than or Equal To 10000 to applyįigure 6- Clear filters Top 2 Countries By Sum of Expenditure. In figure 6, after deselecting France, the previous filter of values Greater than or Equal To 10000 will still be applied to the result. When using filters, it is important to clear the filters after using them, else, they will apply to our next selection or use of the filter. We will insert the amount ( 10000 ) into the dialog box and click OKįigure 4- Value Filter (Country) dialog boxįigure 5- Clients Whose Expenditure is Greater than or Equal to 10,000. We will select Greater Than or Equal To. We will click on the drop-down arrow of Row Labels. If we want to know the client(s) that spent less than 10,000 at once, we will do the following: With the data in our Pivot table, we can use the value filter to check all client expenditure for those lesser than a particular amount. We will use the created pivot table in figure 2 to illustrate how the filter tool works for Pivot Tables.įigure 2- Setting up the Data Value Filters. #EXCEL PIVOT CHART FILTERING A FILTER HOW TO#
The steps below will walk through the process.įigure 1- How to Filter Large Amounts of Data in a Pivot Table Setting up the Data For instance, we can retrieve values between a certain number and another. We can use the filters in our PivotTable to retrieve values that we are interested in. Learn How to Filter Large Amounts of Data in a Pivot Table
0 kommentar(er)
