I am trying to exclude some data that loads from a table. There are 5 different values included on the table, and I really only need 3 of them to show. We can call the table "Product" and the values could be:
A
B
C
D
E
I only need A,B,C to load, not D and E. What function should I be using to exclude that data?
You can simply use a WHERE statement to exclude or select values we need . A another option, you can create a calculated dimension with a IF statement: = IF( Match(Field, 'A','B','C'), Field, NULL())
You can simply use a WHERE statement to exclude or select values we need . A another option, you can create a calculated dimension with a IF statement: = IF( Match(Field, 'A','B','C'), Field, NULL())
