Ticket #14476: patch

django/db/models/sql/query.py

@@ -1008 +1008 @@
             having_clause = value.contains_aggregate
 
         for alias, aggregate in self.aggregates.items():
-            if alias == parts[0]:
+            if alias in (parts[0], LOOKUP_SEP.join(parts)):
                 entry = self.where_class()
                 entry.add((aggregate, lookup_type, value), AND)
                 if negate: