Show part codes only whose have Book qty bal.in Pivot table
I have a pivot table with so many part code with Sloc ( Storage Location ).It is possible that a part code who have book bal is zero in a location but have a book bal. in another location.
Now,I want to make a pivot table purely those parts who have book bal.more than zero in a location.Means part code who have not book bal.,should not appear in the pivot table.Is it possible?
For more clarification,please refer attach sheet.
Regards
Pradeep Kumar Gupta
|