Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have two tables:
TABLE_A
Field_1 | Field_2 |
1 | 920001 |
2 | 920002 |
2 | 920001 |
4 | ... |
5 | .. |
TABLE_B
Field_3 |
920001 |
920002 |
.... |
NOTE: Field_2 is a subset of Field_3 and Table_A and Table_B must be unlinked
I have a pivot with Field_3 and Field_1 in dimension and I want to show only Field_1 that has Field_2 in Field_3 and the Field_1 thas has Field_2 null because the field_1 is valid only for Field_3=Field_2 (when declared)
NOTE2: If it helps I can add in Table_A all possible Field_1
Gab
This seems to work as a calculated dimension
=If([Cod. Business] = BUS or Len(Trim(BUS)) = 0, ID)
Have you tried doing something like this
Sum(If(Field_3 = Field_2, Measure))
I can't use this solution because I need null and 0 expression, so I can't suppress it.
I need a solution for a calcualted dimension. I tried to use:
aggr(if(WildMatch(
Concat(DISTINCT Field_3),'*'&Field_2&'*')>0,Field_1,Null()),Field_1)
but it works only for Field_1 having only one Field_2.
I tried, to concatenate Field_2 value for each Field_1 but I can't use it in wildmatch
I am not sure I am able to follow... are you able to share a dummy sample where we can see the issue?
See attached.
ID 12 does not has limitation so it's correct to see in pivot.
ID 1364 ha limitation. It must be visible only on Cod.Business 9200063 and 9200096, so it must not be shown on 9200060.
Gab
@sunny_talwar do you have any idea?
This seems to work as a calculated dimension
=If([Cod. Business] = BUS or Len(Trim(BUS)) = 0, ID)