# Sorting bar chart in Tableau by one category of bars

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

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:

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.

• Uh, OK, why exactly the downvote? – sparc_spread Jul 19 '17 at 16:54

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