-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$ – sparc_spread Jul 19 '17 at 16:54
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, privacy policy and cookie policy

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