Forum Discussion
patyk
8 years agoFrequent Visitor
SETTING UP PAGE FILTER
I would like to know if I can filter page using String (one of my columns) in exclude rows that end with 3 or end with S or end with B thank you
- 8 years agoThere is a workaround to do it. Create a new column
If( right(string,1)="3","exclude",If( right(string,1)="S","exclude",If( right(string,1)="B","exclude","include"))).
This will give you include and exclude. Use this column in page level filter. Hope this solution works for you
Shantanu00007
Helper I
8 years agoThere is a workaround to do it. Create a new column
If( right(string,1)="3","exclude",If( right(string,1)="S","exclude",If( right(string,1)="B","exclude","include"))).
This will give you include and exclude. Use this column in page level filter. Hope this solution works for you
If( right(string,1)="3","exclude",If( right(string,1)="S","exclude",If( right(string,1)="B","exclude","include"))).
This will give you include and exclude. Use this column in page level filter. Hope this solution works for you