Excel - Two Sets of Subtotals / Subtotals Above the Data - Episode 1498

Microsoft Excel Tutorial: Two Sets of Subtotals / Subtotals Above the Data Welcome to another episode of the MrExcel podcast, sponsored by MrExcel.com. In today's episode, we will be discussing how to create dual subtotals at the top of your Excel data. This question was sent in by Amelie from Belgium, who is trying to add subtotals for both region and product, but with a twist - she wants them to appear at the top of the data. To start, we would normally use the "Subtotal" function under the "Data" tab and select "At each change in region" and "At each change in product". However, in this case, we need to uncheck the option for "Summary below data" and instead, the summary will appear above the data. This will give us the subtotals for each region at the top, followed by the subtotals for each product. But, if you're looking to have the product subtotals at the bottom and the region subtotal at the top, unfortunately, there is no easy solution for that. However, if you have any suggestions or solutions, please email them to me at [email protected] and we may feature them in a future podcast. If the issue is with the grand total appearing at the bottom, you can simply delete that row. But, if you want all the subtotals to appear at the top, then the method we just discussed will work perfectly. I hope this helps you, Amelie, and anyone else looking to create dual subtotals at the top of their Excel data. Thank you for tuning in to this episode of the MrExcel podcast. Don't forget to subscribe to our channel and hit the notification bell to stay updated on all our latest Excel tips and tricks. We'll see you next time for another informative netcast from MrExcel. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-... Table of Contents (00:00) Two sets of subtotals (00:30) Subtotals for Region and Product above the data (00:41) Sorting by two fields (00:56) Adding subtotals above the data (01:13) Adding second set of subtotals (01:47) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: A and B products with totals Data, Subtotal function Dual subtotals at the top East total and West total Grand total Learn Excel From MrExcel Podcast Episode 1498 Seeking a solution for product totals at the bottom and East total at the top Subtotals by region and product Summary above data This video answers these common search terms: A and B products with totals Data, Subtotal function Dual subtotals at the top East total and West total Grand total Learn Excel From MrExcel Podcast Episode 1498 Seeking a solution for product totals at the bottom and East total at the top Subtotals by region and product Summary above data Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads... Microsoft Excel how to add two sets of subtotals and show them at the top of the data. Today, Amelie asks how to add Two sets of Subtotals, with the Subtotals appearing at the top! In Episode #1498 of the Learn Excel from MrExcel Podcast Series, Bill shows us how to get the Subtotals.