MySql like "group by" in elastic search on multiple terms

[shoebmogal]

Hi,

I want to convert the following query in mysql to elastic search:

Select field1,field2, sum(field4), sum(field5) from table1 group by field5,
field6 order by field7,field8

I tried terms facet. But it allows only on one field.

Thanks,
Shoeb