4 Replies Latest reply on Dec 20, 2017 8:26 AM by Jim Dehner

    Columns that regroup  1 and part of 2

    laura delaminne

      Hi all,

       

      I'm new in Tableau and i have a question.

       

      Here is the context.

       

      I have 2 columns "category" and "subcategory".

      Sometimes "subcategoy" has 'NULL' data.

      So i would like to create a third columns "X" that's show me the Subcategories data but when is NULL i would like to have the category corresponding to it.

       

      For example :

       

      Category     Subcategory       3

      Women       Tshirt                 Tshirt

      Men             Trouser          Trouser

      Tshirts          Null               Tshirst

      Baby            shirt               shirt

      Candel         Null               Candel

       

       

      Thanks a lot for your help !!!

       

      Cheers,

      Laura