I want to show data in table chart like below:
Actually data is presenting in table chart as
Product Type Product
However i want to convert this view into like below:
Product Type, Product
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?