Forum Discussion

mazdawd50's avatar
mazdawd50
Copper Contributor
Sep 04, 2020

Pivot table filter function

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.

  • Ramiz_Assaf's avatar
    Ramiz_Assaf
    Iron Contributor

    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

Resources