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
binu_acs
21 - Polaris

@manvi_arora One way of doing this

image.png

Labels
Top Solution Authors