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