Hello everyone - I'm having trouble figuring out how to fulfill some strict requirements that have come my way and wanted to see any of you have experienced a similar use case or might offer some assistance in how to solve this in Tableau.
For privacy, I will use the super sales data and the attached workbook to demonstrate. I am displaying profit ratio (SUM([Profit])/SUM([Sales])) by state and would like to update the view to achieve the following goals:
I've played with LODs and table calcs and have struggled to come up with a solution - any thoughts?
You could create calcs for both Profit and Sales that would look like this:
if [State] = "Massachusetts" AND [subcategory] = "Machines" then [Sales]
elseif State] <> "Massachusetts" AND ([subcategory] = "Paper" OR ...) then [Sales]
Would that work?