Oracle Error ORA-36768: (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.

Oracle Error Message

ORA-36768: (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.

Reason for the Error

An AGGCOUNT variable was specified with different base dimensions than the aggregation variable.

Solution

Select an AGGCOUNT variable with exactly the same base dimensions as the aggregation variable.