13 Replies Latest reply on Oct 15, 2018 9:47 PM by Harry William

    To split the dimension value in a text table

    Harry William

      I am completely new to the tableau. I am trying to create a text table in the tableau but facing the following issue :

       

      I am using two different dimensions in row (portfolio type) and column shelf (party type) with a measure (exposure amount), with my column dimension having four values like 'Corporate', 'Individual', 'Bank - PSU' and 'Bank - PVT'. I wanted to split the 'Bank' in the table as follows :

       

      Total = Bank - PSU + Bank - PVT and

      Bank - PSU

       

       

      Corporate

      Individual

      Bank

      Total

      Bank - PSU

      Portfolio 1

       

       

       

       

      Portfolio 2

       

       

       

       

      Portfolio 3

       

       

       

       

      :

       

       

       

       

      Portfolio n

       

       

       

       

       

      Can you suggest the way by which i can generate the above tables based on dimension value for 'Bank'? Whether i can use the calculated field to resolve it?