In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Pivot with multiple filters

Ariz
7 - Meteor

Hi all 

 

Just wondering how can i put something similar to pivot with multiple filters, please advise if there is anything similar to field list in excel where i can put Filters, Columns, Rows and values.

 

thanks 

ARIZ 

2 REPLIES 2
T_Willins
14 - Magnetar
14 - Magnetar

Hi @Ariz,

 

The Filter tool in Alteryx is pretty powerful and will accept Boolean arguments for multiple filters in one tool.  This works great for a static filter.  If you are looking for a dynamic solution where the user of the workflow can select the filters applied to the results, you will need to create an Alteryx app that the user can select the filters that will be applied to the Filter tool.  If you have sample data and a sample output, the Alteryx Community can assist you with the workflow if you need it.  

Ariz
7 - Meteor

Thanks Willins!

Labels
Top Solution Authors