B02 Group Rows into Categories 1:41
prev < Numbers ’09 > next
1
00:00:01,134 --> 00:00:02,802
Group rows into categories
2
00:00:02,802 --> 00:00:05,939
Numbers ’09 lets you create tables categories
3
00:00:05,939 --> 00:00:07,507
giving you a quick and easy way
4
00:00:07,540 --> 00:00:10,310
to make sense of large data sets.
5
00:00:10,310 --> 00:00:13,513
In this table of Energy Saving Ideas for a home,
6
00:00:13,513 --> 00:00:16,149
the Type column has three different entries:
7
00:00:16,182 --> 00:00:17,350
Heating and Cooling
8
00:00:17,350 --> 00:00:19,686
Appliances and Lighting.
9
00:00:19,686 --> 00:00:22,489
To create categories based on these values
10
00:00:22,489 --> 00:00:24,657
click on the pop up menu in the column header
11
00:00:24,657 --> 00:00:27,727
and select "Categorize by This Column".
12
00:00:27,727 --> 00:00:31,865
Numbers automatically insert
categories rows for each values
13
00:00:31,865 --> 00:00:33,800
and groups the date in your table
14
00:00:33,800 --> 00:00:35,468
based on Heating and Cooling
15
00:00:35,468 --> 00:00:38,304
Appliances and Lighting categories.
16
00:00:38,304 --> 00:00:40,807
You can further organize the date in your table
17
00:00:40,807 --> 00:00:42,909
by creating subcategories.
18
00:00:42,909 --> 00:00:45,578
For example you can create subcategories
19
00:00:45,578 --> 00:00:47,447
based on the type of Utility
20
00:00:47,447 --> 00:00:49,649
Electric, Gas or Water
21
00:00:49,649 --> 00:00:51,651
by categorizing on this column.
22
00:00:53,787 --> 00:00:56,122
To hide or show rows in a category
23
00:00:56,122 --> 00:00:59,759
click the disclosure triangle
in its category row.
24
00:00:59,759 --> 00:01:01,928
For quick view of all your categories
25
00:01:01,928 --> 00:01:05,231
choose "Collapse All" form any
categories rows pop up menu.
26
00:01:06,066 --> 00:01:09,936
You can also summarize data
by using instant calculation.
27
00:01:09,936 --> 00:01:13,506
In the Total column select
"Average" from the pop up menu
28
00:01:13,540 --> 00:01:16,843
to get an average total cost for
the items in each categories.
29
00:01:17,677 --> 00:01:20,280
You can easily promote or demote categories
30
00:01:20,280 --> 00:01:22,949
to get an entirely new view of your data.
31
00:01:22,949 --> 00:01:26,286
Just click on a pop up menu
in one of subcategories rows
32
00:01:26,286 --> 00:01:27,620
and select "Promote".
33
00:01:28,888 --> 00:01:30,657
Now the data is reorganized
34
00:01:30,657 --> 00:01:33,059
by Utility first and then by Type.
35
00:01:33,860 --> 00:01:36,763
Categorizing rows helps
make it easy to organize
36
00:01:36,763 --> 00:01:39,099
and understand large sets of data.
page revision: 4, last edited: 03 Oct 2009 22:03
Done.
MacTutorial Subtitles, Wik-iPad, HTML5 App, FreeSMUG