How to create view based on query which has sum(),group by columns?

Hi there,

I have created Query which return me record set

field1 ,SUM(Field2), SUM(Field3), SUM(Field4) group by Field1

Now i want to create view based on this query but getting errors/ showing unretrieved under aggregate columns.

Regards,

Rahul