XML/BI Publisher - Sub-Total displays

Hi All,

I have one customer requirement to display the report in below format and its data file is below:

<DATA>

<Group>

<Field1>X</Field1>

<Field2>Y</Field2>

...

<Field10>Z</Field10>

</Group>

<Group>

<Field1>X</Field1>

<Field2>Y</Field2>

...

<Field10>Z</Field10>

</Group>

<Group>

<Field1>X</Field1>

<Field2>Y</Field2>

...

<Field10>Z</Field10>

</Group>

... etc many rows/groups

</DATA>

Now I have to display the report in below tabular format with sub-totals:

Header 1	Header 2	Header 3	Header 4	Header 5
Field1	Field2	Field3	... etc fields	Field10
Summary By Field1 - Or Grouping by Field1	Sub-Total of Field2	Sub-Total of Field3	...	Sub-Total of Field10