Now, today, I'm going to give a very short lecture on how basically the triangle tools, OK, groundwater
rocks and of course, this is related to that information.
OK.
In fact, it's not it's not about the bank.
Ultimately, it is the broader picture.
We will now today learn actually how that affects all to a drag and drop everything over there in the
background.
Whole calculation.
But I know in their tax measure we have learned so much.
We know that home of the textbooks, isn't it?
How far into the next world and this is phenomenal.
You just go and put the total a greater tax and put that tax into the pivot.
And when you apply the henders automatically your calculation starts happening.
Right.
According to the.
We saw that.
Then afterwards, we not only learn about politics, but in case if we want to ignore the next right,
then now we learned that the soldat using the oil that's fairly right, that we talked about being all
oil and all selected, that was a phenomenon, in fact, that gives you that extra boost to your energy.
Right.
That gives you more actually capability of handling the data, isn't that right?
We have done this everything.
Now, what is left?
Well, there is one more concept.
I like to talk about it.
You know how basically it looks OK not to do that.
I'm using this binder with this concept that, OK, now these are what I do is I quickly go and create.
So this is the same dude I'm using.
You can see that this is my data, right?
This is my data.
Now, here I have created a tool that functions.
You need to you have already covered these taxes.
The one is distinctly you remember the distant goal to get the unique values.
OK, so I created a function called distinction by the name of Mackney.
OK, so this is the first one.
I want to see the unique items.
You know, in our data, one book is repeated several times as it is, it has been purchased by many
other users to date.
And then there's another text which I have created, which you already know that although the some small
quantity.
OK, because I want to take these two examples.
OK, now, if I created a for example, see what will happen when you create a pivot and you want to
find something to based on the total.
So I put the name here and I put the total quantity here, for example.
OK, now.
If I polluted the zone here, there's always that order.
OK, see this, what happens?
You know that now there's always performance start coming, right?
So you have here to zone performance, which is 50 quantity.
Then you have a hundred and seventeen for the north and then sixty four for the south and the west,
and this is your granddaughter on which we are going to focus today.
Now, three, four, seven arrive.
Almost 90 percent of you will see one because our daughter is full with a hundred and sixteen to sixty
four.
And this is one hundred and seventy and and and this is 50.
So if I add them up, I will have my daughter three, four, seven, isn't it.
So most of you.
Are under the impression that the grand total is nothing, but it is just a total of the above all Hager's
Norgay's you are.
I was out a long few months back until I learned that a U.S. air base, this gag order does not have
to do anything with these borders.
Support that.
No.
Not at all.
In fact, North Dakota has no relationship with the South Dakota.
They all work differently independently of each other.
I often used the word coordinator to how the calculation happens.
I told you before that.
So today we are actually discussing it today.
Now, this the first time quantity is coming obviously from.
So they would say that in mind is to find out the local advance in looking at.
That's right.
And then growing the quantity and give me the total quantity.
So it was except in the eastern zone, we'd go and check.
Right.
So here in the east is all the first would coordinate.
Coordinate is east and then.
Calculation in the background, this is how it happens, and then you have the that which is nine and
you get in nine.
Same happens with The Jungle Book under the East River.
You get the calculational book.
And when it comes to east, so it doesn't make the books right.
Your it goes directly in the zone and it, you know, chased the east and returned to the quantity.
Now I'm telling you all this.
I mean, that's very simple.
Anyone can understand.
After all, it is not a new thing for us.
Right.
You see, the point is now this is about the total.
We calculated the total quantity.
So you can see that it's a coincidence or, you know, I mean, you find a totally equal.
But the the thing is, granduncle, what happened?
The calculations never happens because of these the numbers.
OK, grandchildren meet granddaughter.
It simply goes here and it gives you the grand total.
OK, the quarter point, it never goes into the north and then east and then west and then add them
up, no, it simply goes in the big circle that this is very important.
You need to understand.
Now, I'll give you one explanation here, Nancy.
Let's go into another table now here.
What I do, I show you the district.
OK, you know, the distinct single uniform, any item, if it is coming, that repeatedly they would
be sure that the cold will come on they want that will be considered as a unique item.
I mean, four times if some book is coming, you will find that book only.
Want the point?
No.
Here I have all the books and the distinction obviously would be one one, one make sense.
Right.
Do you know that the display can be it repeating in the database multiple times it took it down to a
doctor.
Right.
So all have the unique and inappropriate 20 unique books.
We can see that.
And that's how you see the twenty.
Now, I'm going to do something here.
Very.
Important, very crazy, you see, and then you understand what I do is I put the zone here.
I want to see the zone without all that is called.
Isn't it can I do that or not?
Of course I can, because, you know, a book can be falling under two thorns treasons, but maybe for
the ones you never know.
Right.
So I put this on here now when I put a zone here, these are all the books available under the EDL.
And that's why you see these books here.
This one one one.
And this is coming at Ford and see what happens with that, not the axis.
Maybe it can also be here.
You shouldn't be surprised, because I think I can be here and there are too, like, for example,
I want to live in the North Atlantic in the east until.
Right, and they are showing that obviously because of the coordinated, coordinated is what is known
and sort of how the calculation happens in your district.
They were basically predicting that east is on the east and bookies, you know, Atlantic City.
And then it is striking that.
What is that?
I mean, if the book is updating, let's say, five times, so strength is going to be while we do that.
Right.
Scene happens or not and see what happens also at.
Agree, right?
But why didn't the water is coming to a party, this is my question to you.
Isn't it strange why the granddaughter is coming to be here at all, if you look at this not sorry here,
but if I had to move the zone, if I had thought.
From here, you remember the priority was to put the zone here when it put the zone here, this calculation
changes.
Now in the West, I have nine.
You need books in the south.
I have eight in the north.
I have Ben and and in the East Ford, you know that.
What does that mean?
It means that in the east, if I feel that they can read 400 books, but out of those 400, only four
are actually unique, which means all the followable celebrating and making it 400 this week.
Right.
So what is the total of all this?
It's 31.
If this is 21, then why the grandcourt is going to be this is that important point, guys, because
grand total has nothing to do with the above calculations.
The West even has nothing to do with the salt.
And salt has nothing to do with the north and east.
They all work independently.
So what happened?
What happened?
First of all, this is clear.
Let me know if you have any doubt why we're looking at why this is giving us one on one, right?
Because in the East, I have only these books available.
Right.
Let me quickly take so little.
We have the E not in the East.
How many books do we have?
Well, these are your books right now.
If these are my books, if I go into the duplicates from this, let's go into another sheet.
OK, so we can use to remove duplicates.
So if I use to remove duplicates, then this is the right.
All the regulations will be removed, isn't it.
My daughter has had no clue.
OK, now you tell me that all the duplicates are equal to what is your unique count for every book?
I mean, one one, one one and total four.
Right.
So that's why I.
You are sitting here for.
Right.
Just count beauty.
This is your total beauty, OK?
Right.
So we're getting four.
So actually, what happens when you go into the granddaughter?
It simply takes what is your tax?
Your tax is all about district court and then it is applied.
You know, the tax district court is applied on your books.
Remember that, right?
This is the one.
This is the one, right?
So it goes in your data, it goes in your data, it picks up the all the books.
And and it finds that how many books it has there, which are supposed to be unique.
So if a book is coming three, three times, multiple times, it is considered as one.
Right.
If book is already there, as you know, it's coming only once.
Then it's part obvious it is going to be considered a game as.
One item in this way, so if I take all the data and now I remove the photos, you see what happened.
My data has let us know it now, you see, this is what you get, all the books, duplicate books are
removed and finally you are left with 20 books.
And that's why you see it can't be understood at the moment.
This is a very, very conflicting thing.
Many Dacula, they don't understand this.
The only one I mean, you know, initially, because on this granduncle is always the sum of the whatever
the hell you use in the spirit, we all mistake them like in this way.
Right.
But at some point in time, you may find this thing initially.
You may or may not be able to see this.
Right.
It may be overlooked as you are a beginner, but eventually when you start working on DACs, you start
doing the complex calculations.
This you will notice and it will be a tablet.
Then you.
Either, you know, will simply just go and ignore that thinking that all might be OK is because this
is what exactly I need, right?
Or the little wonder that, you know, I mean, you start looking here and there that what is happening?
What's wrong?
You started Googling, so this is very, very important point, all the calculations happened in, you
know, Mitchell County, they all happen separately.
There is no relationship between these all Hager's.
This is a very, very important.
The point is, it's not just about the distinction, they can be some other functions, tool which can
work in that way.
OK, so they will go and talk about this in the coming sessions.
So don't worry.
OK, but I'm just making ready for this situation.
So how to handle that right now in this case, you know how to handle that means now in this case you
are happy that OK, I'm getting the right call.
I mean, now I understood why it is coming, but sometimes what happened, not in this specific case,
but in other situations.
You may want to get the total of these and you want to show that in the grand daughter, not about the
distinction, but maybe some other thing.
Maybe you want to take the dog to talk to performers, not talk to performers can be different from
Zillman.
And looking at the entire daddy.
That dog can be different for a while, isn't it?
It is a possibility.
You want to take the dog to talk to in your books, right?
Revenue.
But there's always.
There's always you may have, you know, a bee and then maybe be little.
You just want to take the total revenue.
So talk to add for is doing it hundred dollar for some support, some other reason.
It's wonderful.
It's another goal is to take the but overall it is something else.
Maybe quite getting the point or maybe 150.
I don't know, I mean what it is going to be.
So in that if you maybe want to.
I have this daughter displayed in the granddaughter instead of the granddaughter doing the different
calculation, because when you look at the entire data that Dr. Performace will be different than you
look at, there's always the total revenue numbers will be different.
So ultimately, if your granddaughter is coming different, it is actually what led to you don't want
to show that.
You want to show the granddaughter, according to the Sunways, those numbers.
There then will have to see what we can do, so I'm just kind of preparing you for this upcoming challenge.
It is interesting at the same time, if you understand this, as you have understood to date this,
I'm sure when you create the decks, you will have no more visibility.
You have, you know, more understanding, more confidence, isn't it?
OK, so that was just a quick video for you now.
We will continue with this in excisions.