Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.

Create Pivot with multiple fields grouped at one field

Highlighted
5 - Atom

I am trying to create a pivot sorted on one field (customer name) while other fields (Age, Store Location, Brand, Item) for information i.e. Pivot not sorted on other fields. Similar to pivot in excel where I can subtotal on customer name and sort the pivot table based on Total Spent on same field i.e. customer name. I have attached the sample excel sheet with the desired pivots results that I am looking for. On community, I see solutions when there is only field in Row Labels, however I cannot find anything with multiple rows. Can anyone help me in respect to it please?

Highlighted
5 - Atom

Anyone who can help me with my query please?

Highlighted
9 - Comet

This is one method of accomplishing what you want to do. You can essentially use a summarize tool, group on Customer Name, and sum Number of Visits, Quantity Bought, and Total Spent. Then you can use a formula tool to add "Totals" after their names, union the data, and then sort by customer name. 

 

 

 

Pivot table.PNG

Labels