I have a sheet that consolidates raw inventory and sales.
Raw inventory takes the first few hundred rows. Then I have a query statement that pulls sales data from Cust_Sales.
When I run a pivot table to query this to get Uncommitted inventory, the query portion of the data is not included.
I have edited the data range of the pivot table to just the query portion, and I get a blank pivot table.
Is the result of a query only available for further processing under special circumstances?