Microsoft Office Tutorials and References
In Depth Information
Audience, and Columns
sections of the
Create View page
5. We are not going to sort or filter our view data, and we don’t need to inline edit, but we
are going to use Group By. Click the plus sign in the Group By section to expand it.
6. In the Group By section, in the First Group By the Column drop-down list, select
Category. By default, groups are sorted in ascending order. That’s fine in this example,
so leave the default. At the end of the section are options to have the groups expanded or
collapsed by default and the number of groups displayed per page. Let’s keep the defaults
of collapsed by default and the per page display of .
7. Click the plus sign in the Totals section to expand it, and click the down arrow in the
Total field next to Expires. Select Maximum from the calculations there (Figure 6.27).
Notice that Average is supported only if the view is Datasheet. That’s nice to know, but
we’re not using it for this view.
8. Expand the Style section, and choose Shaded. This will shade the background of every
other row to help them stand out a little.
There is no need to enforce an item limit on the list, because it’s simply not that big. The
list itself isn’t organized by folder, and my example does not use any mobile devices to
access the list. That means that after choosing the style for this view, we’re done.
9. Click OK to create the new list view.