5 Replies Latest reply on Apr 7, 2016 3:21 AM by david marcus

    create a new category/type in an existing dimension from data

    david marcus

      Hi

       

      I have some data where agencies are categorised into a number of sectors. I want to split one of these categories and 're-allocate' agencies to this type.

       

      I could possibly do this in the underlying data, but that data is in a set of about 20 different sheets, and I was hoping there was  a way to do it inside tableau.

       

      A sample workbook is attached. what i want to do is take a sub-set of agencies (about 10 or so) and create a new category with the sector dimension called 'SOC' so i can report/chart comparisons between the three groups of government, councils and SOCs.

       

      Any help appreciated.

      david m