How to create cross tab with multiple level columns dynamically

Hi Kevin,

We are trying to develope group above cross tab report with BI Publisher.

i am unable to achieve multiple level columns dynamically.Using cross tab wizard i can achieve single level measure column ,but not the second level column.

Output should look like this:

Country1

                      Region1         Region2           Region3   --(level1 column)

                    d1   d2   d3     d1  d2  d3        d1  d2  d3 -- (level2 column)

Row1        10     20   30    70   80  90        40  70   90  --data

Row2        21    24    54     65   23  64       64  76   87

Here regions and d1 d2 d3 may vary based on xml data.Also we have page break on country.

Thanks,

Mahesh