community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Filter Custom Row

Meteoroid

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
Highlighted
Alteryx Partner
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

 

Cheers

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"

 

Neil

Meteoroid

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

Labels