2016/01/22

How to group the dimension and customize the group name in Tableau

'Edit group name' is hidden in Tableau. Here is the instructions of how to group the dimensions and customize the group name. I used the default dataset of Superstore on Tableau Desktop 9 as an example. I want to group the sub-categories with number of records smaller than 200 together


Step 1: Build a sheet by dragging the dimension and measures.






Step 2: Use 'Ctrl+shift' to select the sub-categories you want to group. After you group these three sub-categories together, you should see the name of 'Sub-category' change to 'Sub-category(group)' on the top of the sheet. 


Step 3: Click the upside-down triangle on the right of 'Sub-Categor(group)' and choose 'Edit Group...' from the drop-down menu. 


Step 4: Click 'Rename' on the pop-up window. After you see the blue color of the group change to white color, you can start typing directly on 'copiers, machines, supplies'. The next text will automatically rewrite the old text. 


 Step 5: I renamed the group to 'Sub-Categories(<200)'. The order of the sorting changed. 

1 comment:

  1. Hey man thanks for all the work that you do and I really appreciate it. Your blog posts have been useful to me so many times and for that would like to thank you.

    ReplyDelete