I like to bring inventory remaining quantity and consumption into one pivot table. But when I add WHERE, remaining quantity become 0.
My script is like this.
SELECT L.[Remaining Quantity], L.[Quantity], L.[Entry Type]FROM [CRONUS Canada, Inc_$Item Ledger Entry] AS LWHERE L.[Entry Type] = '5'
SQL expert please help. Thank you.
Is it giving you the expected Data result from SQL Side???
If not then you need to cross verify there in before you think from Pivot Table.