[Autogenerated] high in this lesson. I'm
going to show you how to group a
SharePoint list. We're gonna go to our
employees list and our employees list has
115 rows of data with information about
our employees and one of the criteria. One
of the columns is the department, and we
can see here all of the different
departments that we have listed in this
list. What I want to do is group this list
by department. So I'm going to go ahead
and click here on the department header
and come down the little pop up list to
group by department. I'm gonna click on
that and give it a minute. There we go.
And now we can see. Look down on our
department column. Here we are, grouped
together by the individual departments,
and you could see over here on the left It
shows me what I'm group by and how many
members of that group there are. So
there's 16 accountants, 24 cashiers, seven
customer service people, et cetera. And
one of the really cool things is I can
roll these up if I go ahead and click on
this arrow. See that I can roll up these
different groups and I've got a narrow
appeared Let me click that one time So now
they're all rolled up If I click on it
again they're all expanded Come back up to
the top There all rolled up And I can
simply choose which one I want to expand
Pretty cool, huh? Now I can also go ahead
and sort this list. Let's see that I
wanted to sort this list now. Bi hourly
rate. I'm gonna go smallest to largest and
we can see now here in the accounting
group it is sorted within that group and
the same with cashiers, customer service
and so forth. I can also go ahead and
filter this list. Let's go ahead and
filter by part time. I only want to see
part time employees. So now we can see
that I have one part time accountant, 24
part time cashiers, seven customer service
and so on. Now we can save this view if we
want. We go here to save the view as and
if I want to clear it will come up here to
the little filter icon and click on clear
filters. Then I'm gonna go over to my
department head er and again you see that
little symbol there that lets me know that
this list is grouped by that criteria and
a click here again come down to group by
department. We're gonna click on that and
we are no longer grouped. We are, however,
sorted We see the little up arrow here. If
we want to get rid of that, we simply go
up here to the views and click on all
items again. And now my sorting is gone.
My grouping is gone My filtering is gone
and we're back to where we started. Now
you know how to group list items in
SharePoint list. Thanks for listening and I'll see you next time.