1 00:00:04,240 --> 00:00:05,620 [Autogenerated] high in this lesson. I'm 2 00:00:05,620 --> 00:00:07,450 going to show you how to group a 3 00:00:07,450 --> 00:00:09,940 SharePoint list. We're gonna go to our 4 00:00:09,940 --> 00:00:15,240 employees list and our employees list has 5 00:00:15,240 --> 00:00:17,930 115 rows of data with information about 6 00:00:17,930 --> 00:00:21,290 our employees and one of the criteria. One 7 00:00:21,290 --> 00:00:23,290 of the columns is the department, and we 8 00:00:23,290 --> 00:00:25,050 can see here all of the different 9 00:00:25,050 --> 00:00:28,720 departments that we have listed in this 10 00:00:28,720 --> 00:00:31,940 list. What I want to do is group this list 11 00:00:31,940 --> 00:00:34,690 by department. So I'm going to go ahead 12 00:00:34,690 --> 00:00:39,310 and click here on the department header 13 00:00:39,310 --> 00:00:41,810 and come down the little pop up list to 14 00:00:41,810 --> 00:00:45,010 group by department. I'm gonna click on 15 00:00:45,010 --> 00:00:47,810 that and give it a minute. There we go. 16 00:00:47,810 --> 00:00:49,790 And now we can see. Look down on our 17 00:00:49,790 --> 00:00:53,210 department column. Here we are, grouped 18 00:00:53,210 --> 00:00:57,940 together by the individual departments, 19 00:00:57,940 --> 00:01:01,240 and you could see over here on the left It 20 00:01:01,240 --> 00:01:05,010 shows me what I'm group by and how many 21 00:01:05,010 --> 00:01:06,590 members of that group there are. So 22 00:01:06,590 --> 00:01:12,100 there's 16 accountants, 24 cashiers, seven 23 00:01:12,100 --> 00:01:15,050 customer service people, et cetera. And 24 00:01:15,050 --> 00:01:17,460 one of the really cool things is I can 25 00:01:17,460 --> 00:01:20,200 roll these up if I go ahead and click on 26 00:01:20,200 --> 00:01:25,520 this arrow. See that I can roll up these 27 00:01:25,520 --> 00:01:29,730 different groups and I've got a narrow 28 00:01:29,730 --> 00:01:33,530 appeared Let me click that one time So now 29 00:01:33,530 --> 00:01:35,230 they're all rolled up If I click on it 30 00:01:35,230 --> 00:01:39,910 again they're all expanded Come back up to 31 00:01:39,910 --> 00:01:43,440 the top There all rolled up And I can 32 00:01:43,440 --> 00:01:47,540 simply choose which one I want to expand 33 00:01:47,540 --> 00:01:53,790 Pretty cool, huh? Now I can also go ahead 34 00:01:53,790 --> 00:01:56,680 and sort this list. Let's see that I 35 00:01:56,680 --> 00:02:00,000 wanted to sort this list now. Bi hourly 36 00:02:00,000 --> 00:02:05,000 rate. I'm gonna go smallest to largest and 37 00:02:05,000 --> 00:02:06,780 we can see now here in the accounting 38 00:02:06,780 --> 00:02:10,460 group it is sorted within that group and 39 00:02:10,460 --> 00:02:16,270 the same with cashiers, customer service 40 00:02:16,270 --> 00:02:20,810 and so forth. I can also go ahead and 41 00:02:20,810 --> 00:02:23,620 filter this list. Let's go ahead and 42 00:02:23,620 --> 00:02:29,040 filter by part time. I only want to see 43 00:02:29,040 --> 00:02:33,460 part time employees. So now we can see 44 00:02:33,460 --> 00:02:36,230 that I have one part time accountant, 24 45 00:02:36,230 --> 00:02:41,920 part time cashiers, seven customer service 46 00:02:41,920 --> 00:02:52,080 and so on. Now we can save this view if we 47 00:02:52,080 --> 00:02:56,980 want. We go here to save the view as and 48 00:02:56,980 --> 00:02:59,130 if I want to clear it will come up here to 49 00:02:59,130 --> 00:03:04,260 the little filter icon and click on clear 50 00:03:04,260 --> 00:03:09,760 filters. Then I'm gonna go over to my 51 00:03:09,760 --> 00:03:11,760 department head er and again you see that 52 00:03:11,760 --> 00:03:15,440 little symbol there that lets me know that 53 00:03:15,440 --> 00:03:19,690 this list is grouped by that criteria and 54 00:03:19,690 --> 00:03:22,030 a click here again come down to group by 55 00:03:22,030 --> 00:03:25,320 department. We're gonna click on that and 56 00:03:25,320 --> 00:03:30,230 we are no longer grouped. We are, however, 57 00:03:30,230 --> 00:03:33,060 sorted We see the little up arrow here. If 58 00:03:33,060 --> 00:03:35,230 we want to get rid of that, we simply go 59 00:03:35,230 --> 00:03:38,140 up here to the views and click on all 60 00:03:38,140 --> 00:03:41,970 items again. And now my sorting is gone. 61 00:03:41,970 --> 00:03:44,810 My grouping is gone My filtering is gone 62 00:03:44,810 --> 00:03:47,310 and we're back to where we started. Now 63 00:03:47,310 --> 00:03:49,020 you know how to group list items in 64 00:03:49,020 --> 00:03:59,000 SharePoint list. Thanks for listening and I'll see you next time.