Skip to main content
Announcements
Jan 15, Trends 2025! Get expert guidance to thrive post-AI with After AI: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marcobis
Contributor II
Contributor II

Button to filter values

Hi all, I have this table with a dimension called 'Ragione Sociale' and I want to create a button to filter and exclude values starting with  '***', but * is a wildcard; how can this be achieved?

 

Cattura.PNG

Labels (4)
1 Solution

Accepted Solutions
justISO
Specialist
Specialist

Hi, instead of wildcard maybe use left() or index(), like:

if(left([Regione Sociale], 3)='***' , 1,0)...

View solution in original post

1 Reply
justISO
Specialist
Specialist

Hi, instead of wildcard maybe use left() or index(), like:

if(left([Regione Sociale], 3)='***' , 1,0)...