So here is the scenario
Picture the table below
A ,B C
1,H,J
2,H,J
2,L,J
3,H,J
I want all grouped values of dimensions B and C that have an A value of 2 or 3 but have no corresponding value where A is 1.
So in this example the only row would be
2,L,J
something like
select b,c from table
Minus
select b,c from table where a = 1
W,
Don't know your final goal, but below helps?
[B when A=1]
{Fixed :min(if [Column A]=1 then [Column B] end)}
[C when A=1 ]
{Fixed :min(if [Column A]=1 then [Column C] end)}
[Filter]
if [Column B]=[B when A=1] and [Column C]=[C when A=1 ] then "Exclude" else "Show" end
Thanks,
Shin
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.