2 Replies Latest reply on Mar 5, 2012 11:27 AM by stephanie.white

OR'ing Filters

stephanie.white Mar 5, 2012 9:54 AM

I am currently evaluating tableau and cannot find any way to "OR" filters. Example, I want all stores in Europe and North America OR stores with sales volumes > $5 million total regardless of region. I see I can add filters easily for "region =" and "sum(sales) >", but these resolve to AND for the filters, and I cannot find any documentation or discussion showing how to make these two conditions valid if either is true.

1. Re: OR'ing Filters

Tracy Rodgers Mar 5, 2012 10:33 AM (in response to stephanie.white)

Hi Stephanie,

You can do this by creating a calculated field and then filtering on that. Create a calculated field similar to the following:

if [Continent]='Europe' or [Continent]='North America' or [Sales]>5000000 then " True" end

Then, you can place this on the filter shelf and check the True box. Hope this helps!

-Tracy
Like Show 0 Likes(0)

Actions
2. Re: OR'ing Filters

stephanie.white Mar 5, 2012 11:27 AM (in response to Tracy Rodgers)

Tracy, thanks! I am feeling rather Homer(ish) right about now....
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

OR'ing Filters

1. Re: OR'ing Filters

2. Re: OR'ing Filters

Actions

More Like This