Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have 2 tables like below.
S | A |
1 | x |
1 | b |
2 | c |
A | D |
x | x1 |
x | x2 |
b | b3 |
b | b4 |
c | x1 |
c | x3 |
c | x4 |
I created a dimension within a table. The idea is to show unique D values not linked to S.
1st case when no S selected, 2nd case for S selected:
=aggr(if(GetSelectedCount(S)=0,
only(distinct{<D=E({<S={*}>})>}D), -------> this works
only(distinct{$<D=E(1{<S=P(S)>})>}D)) ---------> this doesn't work
,D)
How can I fix this?
Expected result:
if I select S=1 I want to see:
x3
x4
Thanks,
@elinamcastelletta May be try this
=Aggr(
If(GetSelectedCount(S) = 0,
Only({$<D = E({<S={*}>})>} D),
Only({$<D = E({<S=P(S)>}), S>}D)
)
, D)
Hi, thanks but I doesn't work.