Data Model Sort/Order By on Child Group

Hello,

I have a query like:

select f1, f2, f3, f4, f5 from tables...order by  f1, f2, f3

In the Data Model I have created two groups like:

G1

f1

f2

G2

f2

f3

f4

I want the xml data output such that it's sorted as f1, f2, f3. So, G1 is sorted on f1 and G2 is sorted by f2 and f3.

It is my understanding that only G1 is affected by the Order By clause of the SQL and for the child group G2, the position of columns i.e. f2 followed by f3 will be the sort? I am unable to get data sorted f1, f2, f3.