how to add a second level subtotal feature excel
how to subtotal by two levels in excel
how to subtotal multiple columns in excel
excel how to make multiple subtotals
how to add multiple subtotals in excel
how to create multiple subtotals in excel
how to create multiple subtotals in excel?
how to subtotal by two levels in excel
how to subtotal multiple columns in excel
excel how to make multiple subtotals
how to add multiple subtotals in excel
how to create multiple subtotals in excel
how to create multiple subtotals in excel?
Transcript of the video:
Adding two levels of Subtotals is a bit tricky.
Make sure to be careful to sort by Region 1st and then Product.
So sort by region then product.
Click OK. Because of this bug where Cherry and East is next to Cherry and government, which happens occasionally.
You need to add the Subtotal to the leftmost column first.
Subtotal, and each change in region, sales, cost, and profit, Click OK.
Then come right back in Subtotal, this time for the second field: Product.
Here's the key: uncheck this box to Replace Current Subtotals.
You see right now I have three group and outline buttons.
Click OK - now I have four group and outline buttons.
The number 3 shows me each product within East, each product within Government, each product within West.
The number 2 just shows me the region totals.
And the number one the grand total.
And four everything else.
To make this work, make sure the data is sorted properly.
Make sure to start at the outer level first and then add the inner level.
If you like this video please visit TL.Page/MrExcel, Scroll down, you'll find my group lessons and plenty more videos.
Thanks for watching.
Make sure to be careful to sort by Region 1st and then Product.
So sort by region then product.
Click OK. Because of this bug where Cherry and East is next to Cherry and government, which happens occasionally.
You need to add the Subtotal to the leftmost column first.
Subtotal, and each change in region, sales, cost, and profit, Click OK.
Then come right back in Subtotal, this time for the second field: Product.
Here's the key: uncheck this box to Replace Current Subtotals.
You see right now I have three group and outline buttons.
Click OK - now I have four group and outline buttons.
The number 3 shows me each product within East, each product within Government, each product within West.
The number 2 just shows me the region totals.
And the number one the grand total.
And four everything else.
To make this work, make sure the data is sorted properly.
Make sure to start at the outer level first and then add the inner level.
If you like this video please visit TL.Page/MrExcel, Scroll down, you'll find my group lessons and plenty more videos.
Thanks for watching.
