BIRT Report Grouping

Hi All,

I have 5 excel files. All of them have different columns with a common column say Common in all of them.

This common has like 3 different values A,B,C.

I want my report to have like Excel 1 at the top, then Excel 2 below and so on till it reaches final excel file. All these need to be grouped by values A,B,C.

So ideally i would want a report file generated (excel file hopefully) with 3 sheets A,B,C having the data of the 5 excel files segregated into each.

How can i achieve it?

Thanks in advance.