0 Replies Latest reply on Nov 15, 2012 2:15 PM by srisail.mocherla

    How to convert a Excel cross-tab and its formulas into a Tableau workbook

    srisail.mocherla

      I have a simple tablular data in Excel, sample of which is:

       

       

      Header 1Header 2Header 3
      Client_nameprod1_purchased_flgprod_2_purchased_flg
      client_110
      client_210
      clent_301
      Client_411
      client_511
      client_601
      client_701

       

      Would like to visualize this data in the following cross-tab format, the numbers in this cross-tab basically shows the distinct count of clients:

       

                          prod_1  prod_2

       

      prod_1            4         2

       

      prod_2          2           5

       

      Do you think we should use some sort of table calculations to achieve this?