Updating Filter using List Selection

[MM_Chris]

Hi there,

I am a new Alteryx user and I am trying to implement a dynamic filter that updates an original filter based on the selection from the first. I understand that I will need to create a list box and use those values to update the second filter, but when trying to create my list I don't see any values. I only see the data types. I am also using an input from a macro input, so would that have anything to do with why I can't make the appropriate list that I need? I've also thought about using a text box to replace the string that the filter uses to look up the state. I have attached screenshots to show what I've tried. Thank you!

[MarqueeCrew · Accepted solution]

@MM_Chris,

I've attached a sample macro that addresses the problem at hand.  Please do review the macro and see if it solves your need.

Cheers,

Mark

[MM_Chris]

It sure did, thank you Mark!

Best,

Chris