00:00I recently made a video on how to insert subtotal to your dataset table like this.
00:04Links to the video is in the description.
00:06Nonetheless, an individual has suggested an alternate method for computing the subtotal.
00:10Here's a step-by-step guide for that approach.
00:12First, you're going to select all the branch and location from A2 to A27.
00:16Press Ctrl G and you're going to select a special button here.
00:20Select blanks and click OK.
00:22This is going to select all your blanks.
00:24Now you're going to type the formula equal A2 and you're going to press Ctrl and Enter
00:28on your keyboard and this is going to populate all your blank spaces.
00:32Now select the complete data set from A1 all the way down to C27.
00:36Then you go to the data pull down menu here and go outline and click on subtotal.
00:41At each change, you're going to select branch and location and for function, I'm going to
00:45use sum because I'm going to use subtotal.
00:47And then over here, I'm going to subtotal the sales column only and click OK.
00:52Once that's done, you can see all the subtotals are calculated, including your grand total
00:57right at the bottom.
Comments