how to filter different drop downs

Question

Hello all,

I'm trying to create a workflow where user can select the manager name in the drop down menu and based on the selection it shows the all the analyst name that reports only to him in the next drop down. but it's not working.

basically this workflow will select the manager, analyst and then update the asset count.

once you select the manager name in the first dropdown, it should only show the analyst name that reports to him. after that it will update the asset count based on the selection.

I've attached my data set and alteryx workflow. please advise

Note:  The data set contains more then thousand values. I just provided few data vales in excel

regards,

swapsingh2712

asset.xlsx

asset-alteryx.yxwz

atcodedog05 · Accepted Answer

Hi @swapsingh2712

Here is how you can do it. Packaged workflow attached.

Please use this guide to downgrade the packaged workflow https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

Hope this helps : )