1 00:00:00,480 --> 00:00:08,100 In the last video, we have learned about how we can get the unique list from the general, like we 2 00:00:08,100 --> 00:00:11,940 got a distributor export and also. 3 00:00:13,430 --> 00:00:14,630 So here you can see. 4 00:00:16,310 --> 00:00:25,730 We are also having total revenue, so now the requirement is we need to sum up. 5 00:00:26,720 --> 00:00:32,420 The total revenue for each distributor, right? 6 00:00:33,170 --> 00:00:43,280 So at the end, we will have this list and we need another column where it could be summed up all the 7 00:00:43,670 --> 00:00:48,350 relevant quarter revenue for every channel. 8 00:00:49,490 --> 00:00:50,930 So how we can do that? 9 00:00:53,500 --> 00:00:57,970 We need to go to the states and 10 00:01:00,730 --> 00:01:06,340 or we can go to Sellitto and we don't need no list, just remove it. 11 00:01:08,140 --> 00:01:12,640 And here we have to apply one, a group by. 12 00:01:15,030 --> 00:01:19,620 We need to take this call, Janet, and then have to click. 13 00:01:20,940 --> 00:01:22,740 There is one option here. 14 00:01:24,440 --> 00:01:25,210 Grew by. 15 00:01:28,550 --> 00:01:37,700 So in the croppy auction, we have to select our if you have choose and the if you haven't selected 16 00:01:37,700 --> 00:01:42,710 the column channel, then you can change any color to your requirement. 17 00:01:43,340 --> 00:01:45,140 So here we can choose channel. 18 00:01:45,950 --> 00:01:51,260 And no, we need to write one suitable name for the column. 19 00:01:52,460 --> 00:01:55,760 So like we can write his channel. 20 00:01:59,430 --> 00:02:03,350 Channel sales, channel group, channel grouping. 21 00:02:05,760 --> 00:02:14,040 And here we need to and here we have because one operation here we have a lot of operation like some 22 00:02:14,040 --> 00:02:15,300 Eversmann million. 23 00:02:15,930 --> 00:02:19,100 And for this example, we have to choose. 24 00:02:19,910 --> 00:02:21,570 All right. 25 00:02:22,940 --> 00:02:24,200 Because we need. 26 00:02:26,640 --> 00:02:37,120 One table like if I say select static from this table, where's channel the distributor? 27 00:02:37,140 --> 00:02:42,500 So we will get that behavior, all rules and that's it. 28 00:02:43,580 --> 00:02:51,560 Column name, name of the column, name on which we want to perform cropping and then the then you need 29 00:02:51,560 --> 00:02:54,160 to choose the name and then the operation Aldo's. 30 00:02:55,280 --> 00:02:59,110 So with the passage of time, we will learn about all the other functions as well. 31 00:02:59,120 --> 00:03:03,950 But for this video, we just need to focus almost here and click, OK? 32 00:03:05,590 --> 00:03:06,730 And here you can see. 33 00:03:07,750 --> 00:03:10,780 We are again getting groups like. 34 00:03:14,010 --> 00:03:19,110 Because the grouping was on on channel, and then here you can see. 35 00:03:20,110 --> 00:03:27,700 We are getting another column, and here you can see everywhere David is repeating, if we click, if 36 00:03:27,700 --> 00:03:30,880 you click here and you will see. 37 00:03:32,850 --> 00:03:39,300 The whole list of the table that belonged to distribute it wasn't verified. 38 00:03:40,920 --> 00:03:41,850 There are two options. 39 00:03:43,240 --> 00:03:50,530 Either you can click on Tabin or either you can click beside this table, if you click beside this table, 40 00:03:51,190 --> 00:03:53,740 then you will see the result down here. 41 00:03:54,190 --> 00:04:00,500 If you click on the table, then the table that belong to that disparity here. 42 00:04:01,150 --> 00:04:03,120 This is the distributor, right? 43 00:04:03,970 --> 00:04:08,520 So we can write the same thing in escrow or what is happening here. 44 00:04:10,580 --> 00:04:22,400 I have imported the same table in Indian school, so, as I said, order first like a select the state 45 00:04:22,610 --> 00:04:23,180 from. 46 00:04:28,660 --> 00:04:32,920 And generally for the distributor and Ben. 47 00:04:40,540 --> 00:04:43,000 Channel two distributor. 48 00:04:50,520 --> 00:04:58,710 So here you can see we are getting two five one zero rules for the distributor channel and in the same 49 00:04:58,710 --> 00:05:03,520 way we are getting distributor roles for the distributor, wholesale exporter. 50 00:05:06,350 --> 00:05:11,400 So we just need to click close here and right now we are here. 51 00:05:11,770 --> 00:05:12,200 OK. 52 00:05:13,340 --> 00:05:22,100 So in which column we are interested we are interested in the column Total Revenue, write only one 53 00:05:22,100 --> 00:05:25,080 column, we are interested in only one column. 54 00:05:25,230 --> 00:05:32,210 We want need to write one column so that we can get only our total revenue here. 55 00:05:32,490 --> 00:05:38,420 So far, this we need to click on the air column and then you have to go to the custom column here. 56 00:05:40,130 --> 00:05:44,780 And here you can write a column like a single column. 57 00:05:47,180 --> 00:05:49,820 And here we have two. 58 00:05:51,380 --> 00:05:55,690 I'm right here, one formula like Gabin not. 59 00:05:57,010 --> 00:05:58,090 Select Colin. 60 00:06:01,610 --> 00:06:06,620 And then we have to provide one table, the general grouping. 61 00:06:09,630 --> 00:06:18,750 And here we have to write which column we need, so you just go to revenue, 62 00:06:22,170 --> 00:06:23,160 so that's it. 63 00:06:23,820 --> 00:06:25,200 So we just need to click, OK? 64 00:06:27,840 --> 00:06:36,480 So we are getting at our table to table a select column, so there is something wrong, so we just need 65 00:06:36,480 --> 00:06:41,790 to delete the third column and then we again have to click from column. 66 00:06:43,520 --> 00:06:50,540 And we need to right here a single column, for example, and. 67 00:06:52,420 --> 00:06:56,200 The name will be the formula will be spelled out. 68 00:06:59,670 --> 00:07:00,840 Talks like column. 69 00:07:03,050 --> 00:07:14,930 A. We have returned to timetabled table, so we need to delete the first table and this table, this 70 00:07:14,930 --> 00:07:21,980 lekgotla function is to Parramatta's the first one is the table, which is genuine grouping here in 71 00:07:21,980 --> 00:07:23,090 which we are interested. 72 00:07:23,090 --> 00:07:32,070 It is a total revenue total between this one and that's it. 73 00:07:32,390 --> 00:07:41,910 OK, and here you can see we are getting a new column and here again there is table. 74 00:07:42,230 --> 00:07:43,260 So if you click here. 75 00:07:43,850 --> 00:07:48,650 So here we are getting only one column that contained a revenue. 76 00:07:49,680 --> 00:07:54,180 And we are interested in and like we are. 77 00:07:54,210 --> 00:07:58,750 We want to sum up all these numbers and want to display here. 78 00:07:59,460 --> 00:08:03,140 So let's try to write one more column here, because some column. 79 00:08:05,300 --> 00:08:08,000 And we can just cite the name revenue. 80 00:08:13,430 --> 00:08:15,050 And here we are to right. 81 00:08:15,950 --> 00:08:22,040 Let's have a look if there is any function available in tapin table dot some. 82 00:08:24,670 --> 00:08:28,750 See, we don't have some function aggregate. 83 00:08:29,620 --> 00:08:31,360 Aggregate table. 84 00:08:32,420 --> 00:08:32,960 Call them. 85 00:08:35,220 --> 00:08:36,500 Um, OK. 86 00:08:37,520 --> 00:08:42,560 And if we provide a single column. 87 00:08:47,680 --> 00:08:49,230 And click, OK? 88 00:08:52,270 --> 00:08:56,020 Aggregate a lot of that in there is some problem. 89 00:08:57,330 --> 00:09:02,370 We click question column and revenue. 90 00:09:08,690 --> 00:09:15,170 Table, that aggregate table column, and we need to just be careful. 91 00:09:15,200 --> 00:09:25,430 You have to write the proper name for table dot aggregate column and then we have to provide the first 92 00:09:25,430 --> 00:09:29,430 parameter will be table and column as a text. 93 00:09:30,340 --> 00:09:39,620 OK, so this is the name of the table, a single column, and then the name of the column will be total 94 00:09:46,970 --> 00:09:47,540 revenue. 95 00:10:06,780 --> 00:10:13,350 So this formula will not help us because according to the documentation advocate table. 96 00:10:14,400 --> 00:10:18,100 Developed into multiple columns containing aggregate for the table. 97 00:10:18,480 --> 00:10:24,690 So this is not a useful function at the moment, so we can delete it. 98 00:10:25,730 --> 00:10:28,130 And here you can write one more function. 99 00:10:29,670 --> 00:10:34,020 So we need to click here when you right a revenue. 100 00:10:36,730 --> 00:10:41,170 And then we have to separate out Max. 101 00:10:44,550 --> 00:10:45,960 And here. 102 00:10:59,710 --> 00:11:01,010 Table dot. 103 00:11:03,700 --> 00:11:07,600 Max, so this is a function, this one. 104 00:11:14,540 --> 00:11:17,570 And the name of the table is Cenacle. 105 00:11:19,240 --> 00:11:21,970 And then we need to provide the column name. 106 00:11:22,210 --> 00:11:26,350 This is total revenue. 107 00:11:28,870 --> 00:11:29,370 That's it. 108 00:11:29,920 --> 00:11:30,420 And click. 109 00:11:30,430 --> 00:11:35,980 OK, so here you can see we are getting record. 110 00:11:36,850 --> 00:11:43,240 So if you click here distributer and then the maximum value is seven eight five five zero. 111 00:11:44,170 --> 00:11:44,530 Right. 112 00:11:45,500 --> 00:11:51,720 So, again, we are having issues we are not able to get the value from the table here. 113 00:11:52,130 --> 00:11:57,990 So how to convert this record stuff to the table so that we can get one value here? 114 00:11:58,820 --> 00:12:02,300 We will see in the we will see in the upcoming year. 115 00:12:02,720 --> 00:12:09,580 So in this area right now, we have learned that how we can apply different functions to achieve over 116 00:12:10,590 --> 00:12:11,720 what is required. 117 00:12:12,010 --> 00:12:14,400 But still, we are not able to get over that here. 118 00:12:15,170 --> 00:12:21,710 So what we can do is we can provide the list you just need to delete. 119 00:12:22,100 --> 00:12:26,580 And we are here only to channel be and we are getting all the columns here. 120 00:12:27,500 --> 00:12:32,090 So now what we can do is we just need to click some column. 121 00:12:34,030 --> 00:12:39,380 And now what they call it will be a single column. 122 00:12:40,690 --> 00:12:43,390 And here we have to provide one list. 123 00:12:48,210 --> 00:12:57,210 Uh, we need to create funny lists, right, so in the previous week, how we had created a list, we 124 00:12:57,210 --> 00:12:59,780 just need to click this channel. 125 00:13:00,240 --> 00:13:01,130 This is the table. 126 00:13:01,200 --> 00:13:02,400 It is returning on table. 127 00:13:03,000 --> 00:13:06,900 And then we again need to write it. 128 00:13:07,380 --> 00:13:17,280 And the name of the the column, the name of the column was, uh, it is our total revenue. 129 00:13:22,460 --> 00:13:24,920 Lisa, Glenrock. 130 00:13:26,980 --> 00:13:37,750 So here you can see we are getting list, so this list contains I mean, every hotel, a hotel is having 131 00:13:37,750 --> 00:13:43,990 one list and the exporters have winless in the people in the process. 132 00:13:44,170 --> 00:13:44,770 We did. 133 00:13:45,250 --> 00:13:48,660 We get this thing with the help of a single column function. 134 00:13:49,360 --> 00:13:54,270 So, you know, we have lists and then we can add the final step here, custom column. 135 00:13:55,870 --> 00:13:57,370 And here we are to write. 136 00:14:04,400 --> 00:14:06,590 Revenue, some of revenue. 137 00:14:11,810 --> 00:14:16,520 And here we have to write, function off the list, list some. 138 00:14:20,260 --> 00:14:23,520 So they need to remove, so let's start. 139 00:14:23,830 --> 00:14:24,430 And then. 140 00:14:26,300 --> 00:14:34,880 Let's start let's talk some need only one list, so the single column is running a list because we just 141 00:14:34,880 --> 00:14:36,290 need to close here. 142 00:14:37,130 --> 00:14:38,150 And click, OK? 143 00:14:39,210 --> 00:14:42,180 So here you can see we are getting. 144 00:14:44,600 --> 00:14:47,990 The total sum of revenue. 145 00:14:49,280 --> 00:14:55,590 For the distributor, wholesaler and export, so we don't need this to Harlem. 146 00:14:55,720 --> 00:14:59,690 We just need to select the store and click delete. 147 00:15:02,740 --> 00:15:08,590 Remove columns, so we are getting our result here and. 148 00:15:10,740 --> 00:15:18,690 If you want like women and Max and other things, so you can do that easily with the help of a list, 149 00:15:18,690 --> 00:15:23,840 because we are we are having many function, like if I show you here. 150 00:15:24,990 --> 00:15:29,280 So here you can see we are having late start. 151 00:15:29,430 --> 00:15:35,670 And I mean, let's start Mag's and. 152 00:15:38,960 --> 00:15:41,030 There are different list functions. 153 00:15:41,160 --> 00:15:47,060 OK, so we will we will try to cover as much as we can according to the situation at.