You can’t reference a query if the original query has totals. You have to remember to remove all totals fields from the original query that you want to reference.