Filter Custom Row

[kaysonn]

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

[afv2688 · Accepted solution]

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

[LordNeilLord · Accepted solution]

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

[kaysonn]

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