dvm49
Member
I made a pivot chart comparing product quantity from two different warehouses. But the problem is some products in WAREHOUSE_2 may not be available in WAREHOUSE_1 or vice versa.. But I need to capture all products, if the product is not available in the other warehouse then in the Pivot Table I would like to mention it as "Not Available". Is this possible? I have attached what I have tried but the qty but the result seems to be incorrect.