Hi community, I would like to ask what will be the solution available if i want to filter the dataset criteria as below Different data set contains either interim or final. If the data set show as "Interim", then filter out " equal to or more than Period 13 ". If the data set show as "Final" , then include " equal to or more than Period 13". Thank you in advance FIlter Criteria.xlsx

Filter Criteria by product type

Hi community,

I would like to ask what will be the solution available if i want to filter the dataset criteria as below

Different data set contains either interim or final.

Filter Criteria.png

If the data set show as "Interim", then filter out " equal to or more than Period 13 ".

If the data set show as "Final" , then include " equal to or more than Period 13".

Thank you in advance

Ah... Here is a sample workflow that does just that. Custom Filter is a little more complicated:

Is Period 13 a variable?

i.e.

alteryx 1.PNG

Hi @Tam ,

i just amended the question in my original post and feel free to comment.

Thank you.

Why does Period 14 get filtered out too? From your criteria, you can use a Filter Tool with "Custom Filter":

NOT ([Type] = "Interim" AND [Period] = "Period 13")

But that wouldn't match the output you provided. Is there more dynamic logic involved?

Hi @CoG ,

Sorry for the confusion caused, basically i plan to filter period 13 onward which mean if the period more than or equal to 13, then filter out.

Thanks

Ah... Here is a sample workflow that does just that. Custom Filter is a little more complicated:

Good Information attaching equity product information