Hi all,

I have a sheet where I store some records in this - simplified -
format:

Article | quantity
XYZ    |   4
KLM   |  -2
XTR    |   3
XYZ    |  -1

There is a minus sign when it's a shipping, otherwise it's a receiving.
The pivot table adds/subtracts quantities depending on the sign,
and shows for each Article, the quantity available in stock.
Once an article quantity become 0, I would like that row to disappear
from the pivot table,
I dont need a stock list with quantities: 0.

Is there a way to do this (not copying the pivot table and removing
manually the 0 rows...)

thanks