Pivot table filter function

%3CLINGO-SUB%20id%3D%22lingo-sub-1636533%22%20slang%3D%22en-US%22%3EPivot%20table%20filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1636533%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wondering%20if%20it%20is%20possible%20to%20select%20a%20range%20of%20values%20with%20the%20filter%20function%20of%20the%20pivot%20table%20or%20if%20they%20can%20only%20be%20selected%20one%20by%20one.%26nbsp%3B%20Example%3A%26nbsp%3B%20I%20have%20set%20up%20a%20pivot%20table%20of%20renewals%20with%20outstanding%20balances%20but%20some%20of%20the%20balances%20are%20positive%20and%20some%20negative.%26nbsp%3B%20I%20want%20to%20use%20the%20filter%20to%20just%20show%20the%20positive%20(balances%20owing)%20or%20balances%20greater%20than%200.%26nbsp%3B%20There%20could%20be%2020%20to%2050%20items.%26nbsp%3B%20Is%20there%20a%20way%20to%20select%20them%20all%20at%20once%20or%20is%20one%20at%20a%20time%20the%20only%20way.%26nbsp%3B%20Thank%20you%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1636533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1636754%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1636754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F782569%22%20target%3D%22_blank%22%3E%40mazdawd50%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eselect%20the%20drop%20down%20arrow%20and%20apply%20a%20%22Value%20Filter%22%20then%20%22Greater%20than%20or%20equal%22%20select%20your%20proper%20column%20and%20%26gt%3B%3D%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esee%20the%20pic%20as%20an%20example%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am wondering if it is possible to select a range of values with the filter function of the pivot table or if they can only be selected one by one.  Example:  I have set up a pivot table of renewals with outstanding balances but some of the balances are positive and some negative.  I want to use the filter to just show the positive (balances owing) or balances greater than 0.  There could be 20 to 50 items.  Is there a way to select them all at once or is one at a time the only way.  Thank you for your help.

1 Reply

@mazdawd50 

 

select the drop down arrow and apply a "Value Filter" then "Greater than or equal" select your proper column and >= 0

 

see the pic as an example