Sep 04 2020 10:35 AM
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.
Sep 04 2020 11:23 AM
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