We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to Apply a Filter to a column selected via a List box tool ?

manvi_arora
5 - Atom

Hi,

 

I have input data which contains data related to 12 months. Now i am required to work only on one month data for which I have used List box tool for the purpose of selecting month to further proceed with the workflow. 

Further, I am required to filter negative balances for the selected month.

 

For example - if I am selecting September month in the listbox tool, for the next step i want to filter "SEP WFC ENTERED YTD BAL < 0", or in case I am selecting January month column, filter should give me result for "JAN WFC ENTERED YTD BAL < 0"

 

Please find the attached excel sheet for input and expected output.

1 REPLY 1
binuacs
21 - Polaris

@manvi_arora One way of doing this

image.png

Labels
Top Solution Authors