[Autogenerated] Hi. We're here in
SharePoint. We're on our customer sales
list, this list UI created recently from
an Excel workbook. And in this lesson,
we're going to create a new default view
for this list of you that everybody will
see when they come to this site. Now, if
you're familiar with the modern
SharePoint, you know there are ah lot of
things that we can do in terms of our
view, each of our columns has the ability
to sort and filter. We can even go over
here and then save those views for our
individual use. We-can also apply filters
this way as well. There's lots of great
options for us, but what we're going to do
is create a view in our settings. We're
going to create a default view in settings
for this list. Now, before they do that,
we want to take a look at this list. When
we look at all of our columns, they don't
seem to be sorted in any particular order,
not by state, not by city, not by
certainly the name or address. So what we
want to do is we're gonna sort this list
in a particular way. We're gonna actually
do a custom sort where we'll sort by state
and then within each state, we will do by
the most, to the least sales. Now, we also
look at this. We don't need this column.
We don't need telephone numbers. We're
going to get rid of that as well. And
before we even get started with any of
that, I'm going to change title to first
name. Our title column is always here in
SharePoint, but we could rename it. We
can't get rid of it, but we can rename IT
all right now, when we want to create the
view and we're not going to keep this view
the way it is. So we're going to edit this
view, which is all items, and you see, we
have here edit current view when we click
there, it takes us to our settings, the
list settings to edit view. Now we see the
view name is all items. We saw that
already. We're gonna change that. We're
simply going to call this default. Then
we're going to scroll down and look at the
columns. These check marks represent all
the columns that we see. You see that we
have a number of other columns that we can
include these air, all different
SharePoint fields. But we're OK with ones
we want. Except we decided we don't want
telephone number. So we're going to
uncheck that and that will be hidden. That
won't be shown in our view. Next, we want
to change the order of these first two
columns. I would like surname to be the
first column to change that. What I need
to do is come over here to the right and
you see where it says position from left.
And these air, the numbers, these air, the
order, the columns are gonna be shown from
left to right. So I wanna make surname
number one. I select the drop-down, go
ahead and click on number one and see that
it automatically changed first name to-be
in the second position. And that's the way
I want it looking good. So far, we're
gonna scroll down some more. Like I told
you, we want to sort by a column. Well,
the sort by default is by i d which we
don't have. We don't have the i. D column
shown in our list. So we're going to
change that because we want to sort by
state and we're going to do it
alphabetically. A Sending A to Z. If we
wanted to do a descending UI would choose
this radio button. Now within that sort,
we're going to do a second sort sort by
the column sales and this one we're going
to do descending order, highest lowest. So
that means within each state sort it will
show us the highest sales. All right, so
that sorting is good. Now we can filter,
but there's no filters that I need to
apply, But we would have that here, but
we're going to scroll down a little bit
more and we're gonna look at this one
here. Totals. I'm gonna click on the
little plus button there, and it gets
these fields out. Force these controls
here, and what we want to do is add a
total to our sales. So we see this A
sales. So we're going to come across here
and we see it's set to none, but these are
the functions that we can add, but we're
going to go ahead and choose some, and it
will give us the some of our sales this is
pretty neat. There's nothing down here we
need to change. This is all having to do
with mobile views of our site. We're going
to simply click OK, and when we come back,
we see that our list is sorted
alphabetically by state. And if we come
all the way over, we see that within those
sorts within the states, they are sorted
from highest to lowest by the amount of
sales. And we have our total here at the
bottom. Now the nice thing about that is,
if I go ahead and filter by state, let's
just take California, see that it's still
totals just the amounts that are left
visible here in my filter. So pretty cool.
And now this view is the new default view,
and you see default up here. And when
anybody goes away and comes back to the
site, that is the view that they're going
to see because that is now the new default
view. Now, if you want to create
additional views, come up here to the
settings Gear goto list settings. When you
scroll down here, you can click on create
view standard view, and now you can create
another view. But now you can give IT a
name and you can choose if it's a personal
view or a public view. So now you know how
to create views from settings in a
SharePoint list. That's it for this
lesson. Thanks for listening, and I'll see you next time.