You weren't really selecting for states with Furniture>=100000.
Take a look at the CONDITION tab for the filter for STATE that I have in the attached. This gets all records for any state where total furniture exceeds 100000. (You could have a user-defined parameter and compare against that too instead of 100000.)
With all those records selected, create separate calc fields. I did two: TOT FURNITURE and TOT TECHNOLOGY. you can do it for the third.
The calc does this: For each selected record, either set itself to SALES or to zero.
(Pull up DISPLAY DATA and see what gets set in there.)
Now you just have to let Tableau SUM(calc), and that automatically happens when you drag it onto the TOOLTIPS shelf. Make sure it gets displayed in tooltips. (You may have to INSERT it in the tooltips editor.)
State Filter Example 2.twbx 1,007.4 KB
Thanks. It looks like this will work. I will translate it into my actual data and use case and let you know if still struggling.
I see how this is working for you, but I am getting an error in the calculated field saying I cannot mix aggregated and non aggregated fields.
Post a sample workbook with your calc field.
Usually if you have a SUM(whatever) and a [variable] you get this error. To get around it, do:
... Sum(whatever) + ATTR([variable]) ...