How to Create a layout for parent-child table within a single table only

_IshanAgarwal

Summary

We have a requirement wherein we want to create a parent child relationship kind of table within single table only instead of normal master detail form.

Content

We have a requirement wherein we want to create a parent child relationship kind of table within single table only instead of normal master detail form. 

We are able to achieve this requirement via BI Publisher Report layouts but not able to replicate the same in EXCEL template layout. There are few summary level fields on which we want to put the formula which is not feasible in BI Publiser report layouts because of which we have to create excel layouts. 

Attached are the sample xml and layout that we are expecting in excel.

Please let me know how we can achieve the same in excel.