-1
$\begingroup$

I have a bar chart that looks like this (truncated for space, orange label obscured for privacy):

enter image description here

Right now, it is ordered by US state. The color distinction is for something called "Entity".

Here are the set ups for Marks, Columns, and Rows, and the legend:

enter image description here

What I'd like to do is sort the order in which these appear, not by state, but rather by the volume measure for the blue Entity ("Industry"). So, in the example above, the states would be re-ordered to NY, NJ, NV, NM.

Is there a way to do this in Tableau? Thanks.

$\endgroup$
1
  • $\begingroup$ Uh, OK, why exactly the downvote? $\endgroup$ Commented Jul 19, 2017 at 16:54

1 Answer 1

1
$\begingroup$

To my knowledge you have to create an auxiliary variable

If [Entity] == "Industy" THEN [Volume] ELSE 0 END

Then you can sort by this. Right click on State then select sort and choose sort by auxiliary variable.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.