How to Swap Sheets in Tableau
Build a diverging bar chart by using profit on the column shelf and state on the row shelf.
Duplicate that sheet. Move profit to the text mark to create a crosstab
Create a string parameter to allow your user to swap between a bar chart and a crosstab
Create a filter to test if the parameter chosen is “Bar”
[Chart Type] = “Bar”
Set the bar sheet to only true values, and exclude true values on the crosstab.
Add both sheets to a container on a dashboard. Make sure you hide all titles. Only one chart will show at a time.