In Tableau, I have 20 values that I would like to filter in a calculation instead of dragging into filters. This metric will join other metrics in a table that don't have the same filters. It's too many items and I would like to do it in the best and most practical way without typing them in the formula.
So I created a set Dim_Set
Then wanted to do something like :
{EXCLUDE [Dim_Set]: SUM([Calls])}
Items to exclude are more than 20 items and don't wanna do this and hoping for a better way.
If Startswith([typeDescription], "class")=TRUE then "Keep"
Elseif Contains([TypeDescription], "YAIP")=TRUE then "Exclude"
Elseif Contains([TypeDescription], "Lifeskills")=TRUE then "Exclude"
Elseif Contains([TypeDescription], "WorkReadiness")=TRUE then "Exclude"
Elseif Contains([TypeDescription], "Roster")=TRUE then "Exclude"
Elseif Contains([TypeDescription], "Arrival")=TRUE then "Exclude"
Elseif Contains([TypeDescription], "Arches")=TRUE then "Exclude"
Elseif Contains([TypeDescription], "etc...")=TRUE then "Exclude"
Else "Keep"
End
Could you please help?