Need help with dropdown & action tool connecting to filter tool

[AgiGovind]

Hi All,

Below is an example table.  Could you please advise on how to use a dropdown tool for "Region" connecting action tool and filter tool ?
1. So from this table,  How to get an output for a specific region or all region - based on my selection in dropdown ?
2. Further if i use render tool (xlsx). How to make the output file name dynamic ? based on my selection in dropdown. Example : Consumption Asia.xlsx or  Consumption Africa.xlsx

Months	Products	Qty	Region
Jan	Rice	100	Asia
Feb	Wheat	200	Africa
Jan	Barley	300	Europe
Mar	Millet	400	N. America
Feb	Wheat	500	S. America

Thanks in Advance! 

[caltang]

On your first question, refer here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Using-an-Analytic-App-to-updat...

I’m on my phone so I can’t build a workflow on the fly.

[caltang]

On your second question, refer here:

• https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015...
• https://community.alteryx.com/t5/General-Discussions/Automatic-add-date-in-filename/td-p/1143466

[KGT]

And this is a basic app that shows how to do this. Note the selection on the output tool to change File/Table Name. You can use a formula beforehand to construct the entire qualified output name if you like.

Also noting in case you're not aware: To use the interface tools, the workflow will need to be an analytic app (yxwz file). Depending on whether this is for local consumption or gallery publishing, as to how you will configure the output tool location.