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?
The easiest way to do this is to use a Limitation as described here:
To make this work you would probably have to make quarantine quantity your first measure.
Hope this helps