0 Replies Latest reply: May 4, 2017 8:03 AM by Nihhal L RSS

    Data Visualization issue in Table chart

    Nihhal L

      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