D
Dkso
Is it possible and if so how do I recall only quantities greater than zero into a pivot table.
Stock adjustments for items can be made, and some of them will cancel each other out +5 and -5 = 0. This 0 (Zero) qty is still recorded in the pivot table as the adjustments show in the table I am getting the info from but I don't want it to, how do I stop the table from retrieving these lines
Thanks
Dean
Stock adjustments for items can be made, and some of them will cancel each other out +5 and -5 = 0. This 0 (Zero) qty is still recorded in the pivot table as the adjustments show in the table I am getting the info from but I don't want it to, how do I stop the table from retrieving these lines
Thanks
Dean