Pivot Table with filters in Excel

[matuke1998]

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.

[bmcclelland46 · Accepted solution]

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.

Is this helpful?

[matuke1998]

Thank you very much! This worked fine