CODEWITHSUNDEEP
tableau-api
Rewat Sharma
Rewat Sharma

Reputation: 33

Break a filter into two different filters in tableau

I have one column product and other product type.i have two filters Product and Type from them. Now i want to create filter in such a way that i have first filter as 1)Product(where productType=A) and 2nd as 2)Product(where productType=B).

Please let me know how can i achieve this in Tableau.

Currently the data is shown in two columns is like: 

Product         Type
A               New
B               Old
C               Old
D               New
E               New

I want two filters and they should be like this: 

New Product         Old Product
A                       B
D                       C
E

Upvotes: 0

Views: 291

Answers (1)

minatverma
minatverma

Reputation: 1099

Create a calculated field product_a_filter as

case when type = 'A' then product end

use this calculated field as filter .Similarly for product type B.

note you will get NULL as extra value in the filter .

to remove that follow this link below :

remove null from filter

Upvotes: 4

Related Questions