![]() If you go back to the #3 view, you will see the detail records that came along with the subtotal row. All of the Wag More detail rows moved along with the subtotal row. Behind the hidden rows, Excel actually sorted a chunk of records. The top customer, Wag More Dog Store, comes to the top of the data set. ![]() In the figure below, a Revenue column cell is selected, and you are about to click the ZA sort button. ![]() Derek from Springfield showed me that when the data is collapsed in the #2 view, you can sort by any column. Of course, at this point, the customers appear in alphabetic sequence. This is a beautiful summary of a detailed data set. When you click the #2 Group and Outline button, the detail rows are hidden, and you are left with only the subtotal rows and the grand total. But, more importantly, it adds Group and Outline buttons to the left of column A. When you click OK, Excel inserts a subtotal below each group of customers. Choose all of the numeric fields, as shown here. Make sure the Use Function box is set to Sum. Open the At Each Change In dropdown and choose Customer. The Subtotal dialog box always wants to subtotal by the leftmost column. ![]() The data below is sorted by customers in column C.įrom the Data tab, choose Subtotals. Start by making sure your data is sorted. I was doing a seminar in Springfield, and I was showing my favorite subtotal tricks.įor those of you who have never used subtotals, here is how to set them up. This tip is from my friend Derek Fraley in Springfield, Missouri.
0 Comments
Leave a Reply. |