6 hours 3 minutes
another function off Excel, That is ah, kind of similar to grouping is ah, our sub totals. And
in this lesson, I'm going to talk about how to create some tokens,
The name It's clear Generating sub totals off certain Ah,
by the certain parameter in itself And so we need a different kind of table to explain Subtitles and look ATT
This table here would represent some kind of sales data are so basically, we have a product code. We have a location where it was sold and the quantitative was sold in each and every turn shut for each and every brother code. So
Ah, if we click, uh,
and we think on sub total
we get this dial box in which it tells us for a change in product code or in this case, what we're going to use his location sold.
He was function some and somewhat. Ah, and then where do you wouldn't have subtitles to be added to which column in this case quantity.
Now, in order for this to work because you see here it says at each change in location sold,
the only way it will work is Ah, if location sold, column is sorted. So what's cancel
this for a moment? Let's go here.
Let's get consort.
And we just want to sorted based on location sold.
So now it is sorted. So we have
a couple of cities here Austin, Berlin, Charleston, London.
now we can go and click
on sub total.
So for each change in location sold, used functions some
and what do we want to sum? Of course. We want some quantities. So we could be okay.
We got a display, which is similar, like if we were groping
is Ari Rose. So we have Austin, and then we have Austin Total
and we have here the quantities of products that were
sold in Austin.
And then we have Total
Member So some awful these numbers here
and if you look here with some is 9545 which is exactly what these subtitle is.
And then we have it again for Berlin and Charleston
and London. And then again, we have grand total in the end.
So you see these three numbers here? So subtitle gives us three levels off complexity of you
So this one which we get immediately after we performed the subtitle function, is number three.
If you click on number two, what we get is we get on Lee Sum totals and grand total.
And if you click on the one
we get only grand total. So let's be country.
And also you can remove some of these. So So, for example, we don't want to look at Berlin and we don't want to look at details off
Charleston and we're now seeing on Lee the data for Austin and London. But we are seeing subtitles for every location. So this is how it works. So this is
this is useful function again. Like most of the function in data tab, they are mostly there to help you analyze data, especially if you have a lot of them. So you have seen we have quite a lot off data that goes, Ah ah,
Out off What? You can look in one screen,
so either you. So if we go back and expand these,
if you want to analyze this, you have to scroll upon down.
So these subtitles help you remove that need and you can just look att what's important to now. If this stable would be a more complex, it would be even more useful than in this room. So this is all about sub totals,
and let's move on to the next lesson.