Yes you are right. If I remove ID, and name from select and group by it works fine.

But I have to list Employee ID, name along with % percentage compliance by supervisor.

Is there anyway to do this?