Oracle Message QSM-02022 - aggregate selections

ERRORaggregate selections
CAUSEThe capability in question is not supported when the materialized view uses an aggregate expression in the HAVING clause.
ACTIONRe-phrase the query to avoid the use of an aggregate in the HAVING clause.