Here is the issue I am having.

In Trenton Qtys.gv I have a column that only has the WA qtys. I can't seem to add a second filter because its my second Gridview in the work space. When I pull the Trenton column from Trenton Qtys.gv to Items to Order.gv I believe it pulls the first qty from the Trenton column in the Trenton Qty's.gv file. In the screen shot below you can see AM5992 (in red) only has 2 locations WA and ZSS it pulls the 12 over from WA. AM6002 (in green) has 6 locations KI, LI, SW, WA, ZSS, ZZZ. I believe it is pulling the 0 from KI (circled in red) because its the first amount for that item.



How can I get this to show me to correct Qtys?