In the last video, we have learned about how we can get the unique list from the general, like we
got a distributor export and also.
So here you can see.
We are also having total revenue, so now the requirement is we need to sum up.
The total revenue for each distributor, right?
So at the end, we will have this list and we need another column where it could be summed up all the
relevant quarter revenue for every channel.
So how we can do that?
We need to go to the states and
or we can go to Sellitto and we don't need no list, just remove it.
And here we have to apply one, a group by.
We need to take this call, Janet, and then have to click.
There is one option here.
Grew by.
So in the croppy auction, we have to select our if you have choose and the if you haven't selected
the column channel, then you can change any color to your requirement.
So here we can choose channel.
And no, we need to write one suitable name for the column.
So like we can write his channel.
Channel sales, channel group, channel grouping.
And here we need to and here we have because one operation here we have a lot of operation like some
Eversmann million.
And for this example, we have to choose.
All right.
Because we need.
One table like if I say select static from this table, where's channel the distributor?
So we will get that behavior, all rules and that's it.
Column name, name of the column, name on which we want to perform cropping and then the then you need
to choose the name and then the operation Aldo's.
So with the passage of time, we will learn about all the other functions as well.
But for this video, we just need to focus almost here and click, OK?
And here you can see.
We are again getting groups like.
Because the grouping was on on channel, and then here you can see.
We are getting another column, and here you can see everywhere David is repeating, if we click, if
you click here and you will see.
The whole list of the table that belonged to distribute it wasn't verified.
There are two options.
Either you can click on Tabin or either you can click beside this table, if you click beside this table,
then you will see the result down here.
If you click on the table, then the table that belong to that disparity here.
This is the distributor, right?
So we can write the same thing in escrow or what is happening here.
I have imported the same table in Indian school, so, as I said, order first like a select the state
from.
And generally for the distributor and Ben.
Channel two distributor.
So here you can see we are getting two five one zero rules for the distributor channel and in the same
way we are getting distributor roles for the distributor, wholesale exporter.
So we just need to click close here and right now we are here.
OK.
So in which column we are interested we are interested in the column Total Revenue, write only one
column, we are interested in only one column.
We want need to write one column so that we can get only our total revenue here.
So far, this we need to click on the air column and then you have to go to the custom column here.
And here you can write a column like a single column.
And here we have two.
I'm right here, one formula like Gabin not.
Select Colin.
And then we have to provide one table, the general grouping.
And here we have to write which column we need, so you just go to revenue,
so that's it.
So we just need to click, OK?
So we are getting at our table to table a select column, so there is something wrong, so we just need
to delete the third column and then we again have to click from column.
And we need to right here a single column, for example, and.
The name will be the formula will be spelled out.
Talks like column.
A. We have returned to timetabled table, so we need to delete the first table and this table, this
lekgotla function is to Parramatta's the first one is the table, which is genuine grouping here in
which we are interested.
It is a total revenue total between this one and that's it.
OK, and here you can see we are getting a new column and here again there is table.
So if you click here.
So here we are getting only one column that contained a revenue.
And we are interested in and like we are.
We want to sum up all these numbers and want to display here.
So let's try to write one more column here, because some column.
And we can just cite the name revenue.
And here we are to right.
Let's have a look if there is any function available in tapin table dot some.
See, we don't have some function aggregate.
Aggregate table.
Call them.
Um, OK.
And if we provide a single column.
And click, OK?
Aggregate a lot of that in there is some problem.
We click question column and revenue.
Table, that aggregate table column, and we need to just be careful.
You have to write the proper name for table dot aggregate column and then we have to provide the first
parameter will be table and column as a text.
OK, so this is the name of the table, a single column, and then the name of the column will be total
revenue.
So this formula will not help us because according to the documentation advocate table.
Developed into multiple columns containing aggregate for the table.
So this is not a useful function at the moment, so we can delete it.
And here you can write one more function.
So we need to click here when you right a revenue.
And then we have to separate out Max.
And here.
Table dot.
Max, so this is a function, this one.
And the name of the table is Cenacle.
And then we need to provide the column name.
This is total revenue.
That's it.
And click.
OK, so here you can see we are getting record.
So if you click here distributer and then the maximum value is seven eight five five zero.
Right.
So, again, we are having issues we are not able to get the value from the table here.
So how to convert this record stuff to the table so that we can get one value here?
We will see in the we will see in the upcoming year.
So in this area right now, we have learned that how we can apply different functions to achieve over
what is required.
But still, we are not able to get over that here.
So what we can do is we can provide the list you just need to delete.
And we are here only to channel be and we are getting all the columns here.
So now what we can do is we just need to click some column.
And now what they call it will be a single column.
And here we have to provide one list.
Uh, we need to create funny lists, right, so in the previous week, how we had created a list, we
just need to click this channel.
This is the table.
It is returning on table.
And then we again need to write it.
And the name of the the column, the name of the column was, uh, it is our total revenue.
Lisa, Glenrock.
So here you can see we are getting list, so this list contains I mean, every hotel, a hotel is having
one list and the exporters have winless in the people in the process.
We did.
We get this thing with the help of a single column function.
So, you know, we have lists and then we can add the final step here, custom column.
And here we are to write.
Revenue, some of revenue.
And here we have to write, function off the list, list some.
So they need to remove, so let's start.
And then.
Let's start let's talk some need only one list, so the single column is running a list because we just
need to close here.
And click, OK?
So here you can see we are getting.
The total sum of revenue.
For the distributor, wholesaler and export, so we don't need this to Harlem.
We just need to select the store and click delete.
Remove columns, so we are getting our result here and.
If you want like women and Max and other things, so you can do that easily with the help of a list,
because we are we are having many function, like if I show you here.
So here you can see we are having late start.
And I mean, let's start Mag's and.
There are different list functions.
OK, so we will we will try to cover as much as we can according to the situation at.