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?