1 Reply Latest reply: Feb 28, 2018 8:30 AM by Erik Wetterberg RSS

    filter on object

    Rani Bosch

      good day,

       

      I have a pivot table as an object on my sheet.

       

      I sum the total quantity items sent to quarantine, total quantity purchased, and then I show the quarantined items as a % of total purchases.

       

      this is done per lot no.

       

      how can i filter out the 0 quarantine quantities out of my pivot table?