Data Visualization issue in Table chart

[nihhalmca]

Hi All,

I want to show data in table chart like below:

Actually data is presenting in table chart as

Product Type   Product

A                  A1,A2,A3

B               B1,B2,B3,B4

However i want to convert this view into like below:

Product Type, Product

A     A1

       A2

       A3

B

      B1

      B2

      B3

      B4

How can i present data in table chart as above.

I tried Aggr(Concat(Product,chr(10)),Product Type)

I  can see data as i expected when i keep cursor on data, please have a look at attachment.

Is it limitation in table chart?

Thanks,

Nihhal