Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Excel Pivot Table with multiple rows and columns

Highlighted
6 - Meteoroid

Is there a way to have a sum/count/grouping as the "values for new columns" within the Cross Tab tool? Say for this example my data looked like this: 

data.PNG

I want Asset and Liability to become headers (like phone number 1 and phone number 2) and then I want to sum the Market Values grouped by Classification and count the number of Record IDs grouped by Classification. Can I do this using a combination of this cross tab tool and a summarize tool? Ideally I would want it to look like the pivot table in excel below.

pivot.PNG

Highlighted
7 - Meteor

I believe this will give you what you want. It sounds like you know how the crosstab and summary tools work just weren't able to figure out the combination. Let me know if you have any questions though and I can explain what's going on or if you need something different.

 

AlteryxCommunitySolution_Crosstab1.pngAlteryxCommunitySolution_Summary1.pngAlteryxCommunitySolution_Summary2.pngAlteryxCommunitySolution_Crosstab2.pngAlteryxCommunitySolution_JoinMultiple.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

-Robert

Highlighted
6 - Meteoroid

That worked! Thank you!

Labels