remove values from filter

[Anonymous]

I have a filter site thant conatains

1

2

3

100

102

I need to remove in some sheets values 100 and 102

How to do it ?

[miguelbraga]

Can you please elaborate better your question. I think I didn't understood correctly.

Regards, MB

[#3]

Try using a "WHERE" Clause to remove rows that contain unwanted values.

i.e.

LOAD *

FROM [Data]

WHERE not MATCH([Value],'100','102') ;

[Anonymous]

If i understood correctly,add a calculative dimension like mentioned below;

if(Filter site <>100 or Filter site <>102,Filter site)

Hope this helpful

Regards,

Imran K