can you filter by subtotal on excel?
how to keep subtotal in excel when filtered?
how do i get a subtotal with filters in excel?
how do i subtotal filtered data in excel?
how to get subtotal in excel after filter?
how to subtotal data in excel with filters?
how to subtotal in excel with filters?
how to use subtotal in excel with filters?
how to keep subtotal in excel when filtered?
how do i get a subtotal with filters in excel?
how do i subtotal filtered data in excel?
how to get subtotal in excel after filter?
how to subtotal data in excel with filters?
how to subtotal in excel with filters?
how to use subtotal in excel with filters?
Transcript of the video:
I was a little surprised by the number of search terms where people were trying to use filters and subtitles at the same time.
And amazingly, it works pretty well with one weird change, right?
So here at the end of Apple, the last record is East.
And just to make this as most likely to fail as possible.
I'm going to get rid of the east.
And then here under Data, Subtotals.
At each change in product.
We're going to use a sum function for sales.
And click OK.
And so adding these up we do get 54.
And, let's see if I remove the clear the filters.
It did put the filter in the right spot.
So even though East Apple was hidden, it knew to put the filter in the right spot.
But then I think the problem that people are having is when they go back and apply a filter.
So let's say we want to see everything from the West region.
Click OK, the subtotals disappear. Alright, so the - I'm going to use air quotes around “simple” - the simple solution seems to be whatever you're choosing here from Region, add blanks in as well.
So now we have 32 + 4 = 36.
That's right, 32 + 4 is equal to 36.
That's right.
We'll try West and Central.
Click OK.
We got 32, 48, 52, 54.
Yeah it it really seems like it works.
Provided when you apply subsequent filters, that you choose the (Blank).
And of course that you don't have any other regions that are actually blank.
If you like these videos, please, down below, Like, Subscribe, and ring the bell.
And amazingly, it works pretty well with one weird change, right?
So here at the end of Apple, the last record is East.
And just to make this as most likely to fail as possible.
I'm going to get rid of the east.
And then here under Data, Subtotals.
At each change in product.
We're going to use a sum function for sales.
And click OK.
And so adding these up we do get 54.
And, let's see if I remove the clear the filters.
It did put the filter in the right spot.
So even though East Apple was hidden, it knew to put the filter in the right spot.
But then I think the problem that people are having is when they go back and apply a filter.
So let's say we want to see everything from the West region.
Click OK, the subtotals disappear. Alright, so the - I'm going to use air quotes around “simple” - the simple solution seems to be whatever you're choosing here from Region, add blanks in as well.
So now we have 32 + 4 = 36.
That's right, 32 + 4 is equal to 36.
That's right.
We'll try West and Central.
Click OK.
We got 32, 48, 52, 54.
Yeah it it really seems like it works.
Provided when you apply subsequent filters, that you choose the (Blank).
And of course that you don't have any other regions that are actually blank.
If you like these videos, please, down below, Like, Subscribe, and ring the bell.
