Is there a reason that a dashboard with 3 worksheets for each of the 3 conditions would not work? If it has to be in a single view then I think the only solution I can figure out would be to do a union across 3 copies of the data with a common field name that Segment/State field in the one instance where State has to be on the left.
This sounds like a good opportunity to utilize Tableau Prep to fix your data up as desired before bringing into Tableau.
Thanks for the response. It's one data source, so shouldn't (I don't think!) be a data cleaning issue.
I'm trying to use one source to find out what the bigger driver is on the business - am I successful because of a certain geography? Because of a certain product? Because of a certain retailer which is pushing the product? While I can run these three analyses separately, and create three separate tables, it's more informative to the user if they can only see the key drivers. For instance, if the biggest three drivers are 3 different retailers, but there's no real geographical or product influence, showing the best geos or products isn't really very helpful to the user.
So yeah as a workaround the three solutions separately will work but I was hoping for something more elegant. Perhaps it's out of scope, it's probably a rare problem that people face...