How to hide abc in the Tableau?

Quote From:http://thevizioneer.blogspot.com/2014/04/day-7-no-more-abcs.html

Superstore  data set has been working for us and I don't want to stop a good thing - 'If it ain't broke, don't fix it' right?  We'll start by making a crosstab of headers.  I'm going with Region, Department, and Category on the rows shelf.  It should look like this:

Here comes the hack.  There's a number of steps to this one (so it's not always worth the trouble - use your discretion).  Here we go.  
 
You're going to have to create two calculated fields so let's go ahead and make those.  The first one you'll make is what I like to call "Blank" and it's calculation is: FLOAT("")
This one can be used over and over again, on every sheet you want to use this trick.
 
The other calculated field we're going to make is going to have the same name as the right-most dimension on the rows PLUS a space (because you can't create a calculated field with the same name as one that already exists in Tableau).  In our case the name of the this calculated field is going to be "Category ".  It's formula is going to be the same as the first one: FLOAT("")

There's a chance Tableau put one of those fields in Dimensions - if so, drag it down to measures.  Now we're going to add Measure Names to the Filter and select the two calculated field we just created:

Next take "Measure Names" to the columns self and add Measure Values to the text shelf.  Things should look like this:

We're almost there.  Take the original dimension "Category" and put it on the text shelf.  Now right click the header that says "Blank" and select Hide.  Lastly, on the rows shelf, right click the "Category" dimension and uncheck "Show Header".  You should now see this:

 

Finish it off by clicking on the text shelf and making it left justified (it is test you know :)).

posted @ 2016-07-18 14:38  蔡哥小弟  阅读(372)  评论(1编辑  收藏  举报