Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?


Filter Custom Row


Hi, Could some provide guidance how to perform filter on custom row? For example, I want to filter only MPTO12000 - Consumer Discounting and MPTO22020, should i use filter function or multirow formula function? Appreciate your advice.


Account Name
MPVO10000 - Sales Volume (in base UoM)
MPTO11000 - Recommended retail price (RRP)
MPTO12000 - Consumer discounting (if legislation allows)
MPTO13000 - Consumer price turnover (CPTO)
MPTO21010 - Retailer margin standard
MPTO21010P - Retailer margin
MPTO21000 - Trade margin
MPTO22021 - Customer allowances (discounts)
MPTO22020 - Customer allowances
MPTO22030 - Trade pay for performance
MPTO22000 - Trade credits & payments
Alteryx Partner

Hi @kaysonn ,


For that use better the filter tool. Set the following formula on the custom filter:


< Contains([Account Name], "MPTO12000 - Consumer Discounting") OR Contains([Account Name], "MPTO22020") >


This will filter all the lines which contain either MPTO12000 - Consumer Discounting or MPTO22020



Alteryx Certified Partner

Hey @kaysonn 


If you want to just filter on the 2 rows (one containing MPTO1200 and MPTO22020) you can use the following formula in the filter tool:


Contains(Field1,"MPTO1200") OR Contains(Field1,"MPTO22020")


Alternatively you could also make use of the StartsWith function like so:


StartsWith(Field1,"MPTO1200") OR StartsWith(Field1,"MPTO22020"




thanks for the advice and the solution works well. Appreciate your guidance!