Filtering by condition

[VK11]

Hello Everyone, I would like to filter the items by using the condition when FQ=1 then Count =1 and FQ=2, then Count=2 and goes on.

The result would be similar to the attached picture. please help as I am new to alteryx

Thanks and Regards

VK11

[alexnajm]

It sounds like the Filter would just be [FQ]=[Count] then!

[VK11]

FQ=Count gets only this

[alexnajm]

Yes that's correct - that's the condition that you set out in the initial post. Can you clarify then your end goal? Are you trying to output to multiple sheets in the same excel file based on the count condition?

[alexnajm]

If you are just trying to Filter to each part, you can stack Filters to where Count=1, Count=2, Count=3, etc. Like this:

[Ranga116]

It's simply the condition i.e  [FQ]=[count]