4 Replies Latest reply on Dec 27, 2018 7:21 AM by Paul Wachtler

    How to create subcategorize of data fields within Tableau

    Douglas Brockbank

      Suppose I have a Dimension called "Location" with 12 distinct data values In it (e.g. North1, North2, North3, East1, East2, East3, South1, South2, South3, West1, West2 and West3). This 'Category' field comes from the data warehouse and I can't modify that data. However, in Tableau, I simply want to create 4 subcategories and group them with these values like this below. I then want to drag the new "Region" field to a column or row so I can compare North, East, South and West. How can I do that?

       

      North

      North1

      North2

      North3

       

      East

      East1

      East2

      East3

       

      South

      South1

      South2

      South3

       

      West

      West1

      West2

      West3