Creating a reference to a query that has totals produces an error

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.