As the title reads, I simply would like to filter my rows based on specific values on the different columns, for example see table below:
I need to filter to only show rows where Cold D has a date (i.e. NOT null or 0-0-0) AND Col A, Col B,Col C are null OR 0-0-0.
So table above should filter to only rows: 1,3,6,10
Is this possible?
You could create a calculated field and then filter based on the result of the formula:
Create "Filter Formula 1" as
IF IFNULL([Col D] ,'0-0-0') <> '0-0-0'
AND IFNULL([ColA],'') <> ''
AND IFNULL([ColB],'') <> ''
AND IFNULL([ColC],'') <> ''
Then filter on your calculated field to display 'Show' only.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...