How can I get around ORA-28500 when access til MSSQL with DBlink using group by statement

I am getting this error:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

[Oracle][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Each GROUP BY expression must contain at least one column that is not an outer reference. {HY000,NativeErr = 164}[Oracle][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The batch could not be analyzed because of compile errors. {HY000,NativeErr = 11501}

ORA-02063: preceding 2 lines from DWH_KVDSA

using a statement like this:

See attatch file.

----------

I think it is the group by statement in there is the problem.

If i run kode with out the two group by i works. (results gives no meaning)