In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Pivot Table with filters in Excel

matuke1998
5 - Atom

Hi, I'm very new to Alteryx and I'm trying to make a pivot table like the one in the image, where I can filter twice, coming the info from the same database.

2 REPLIES 2
bmcclelland46
10 - Fireball

You can accomplish this in many different ways - assuming you just want the output I ran some test data and a simple workflow. You can adjust the filter or leave in the summarize tool a 'Groupby' for the AP filter.

 

bmcclelland46_0-1597069091459.png

 

Is this helpful?

matuke1998
5 - Atom

Thank you very much! This worked fine

Labels
Top Solution Authors