This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.