Data Grouping and Drill Down
This report shows the grouping of sales data into two groups. One group corresponds to the product and the other (internal group) corresponds to the time interval. Each node in the group tree can be examined with the help of Drill Down.
Quarter
Quantity
Product
OrderDate
Unit Price
Price

01.95
Douglas' Red Apples
120
1/19/95  6:52:13 PM
1.86
223.20
1.000
1/25/95  1:38:01 AM
1.86
1,860.00
640
1/26/95  9:56:03 AM
1.86
1,190.40
360
2/3/95  10:40:03 PM
1.86
669.60
400
3/4/95  5:25:10 AM
1.86
744.00
800
3/6/95  8:21:33 AM
1.86
1,488.00
240
3/6/95  8:24:04 PM
1.86
446.40
3.560
6,621.60
04.95
680
4/13/95  6:36:39 PM
1.86
1,264.80
1.080
4/17/95  8:58:28 AM
1.86
2,008.80
320
4/20/95  12:26:50 AM
1.86
595.20
640
4/24/95  11:21:51 AM
1.86
1,190.40
280
5/17/95  4:35:06 AM
1.86
520.80
1.400
5/18/95  7:19:44 AM
1.86
2,604.00
1.280
6/18/95  6:36:06 PM
1.86
2,380.80
5.680
10,564.80
07.95
880
7/2/95  3:18:53 AM
1.86
1,636.80
680
7/25/95  10:28:09 PM
1.86
1,264.80
920
8/18/95  7:43:26 AM
1.86
1,711.20
80
9/6/95  6:16:35 AM
1.86
148.80
800
9/21/95  8:12:27 PM
1.86
1,488.00
3.360
6,249.60
10.95
1.200
10/5/95  9:14:03 AM
1.86
2,232.00
440
11/8/95  5:21:22 AM
1.86
818.40
440
11/17/95  11:06:58 AM
1.86
818.40
720
11/22/95  6:39:38 AM
1.86
1,339.20
2.800
5,208.00

01.95
Tyson's Blueberries
720
1/24/95  3:15:16 AM
0.44
316.80
360
2/1/95  7:02:01 PM
0.44
158.40
600
2/14/95  8:31:41 AM
0.44
264.00
640
2/16/95  1:21:20 AM
0.44
281.60
1.200
2/21/95  2:08:06 AM
0.44
528.00
680
2/22/95  3:42:04 AM
0.44
299.20
920
2/25/95  12:16:47 PM
0.44
404.80
1.360
2/26/95  4:06:56 AM
0.44
598.40
880
3/2/95  2:29:55 AM
0.44
387.20
200
3/20/95  6:05:42 AM
0.44
88.00
640
3/22/95  9:12:42 PM
0.44
281.60

© 2005-2024, i-net software GmbH
Page 1

Quarter
Quantity
Product
OrderDate
Unit Price
Price
8.200
3,608.00
04.95
Tyson's Blueberries
1.000
4/6/95  2:11:14 AM
0.44
440.00
960
4/15/95  3:08:39 AM
0.44
422.40
120
4/21/95  7:54:02 PM
0.44
52.80
480
4/22/95  3:00:46 PM
0.44
211.20
1.240
4/23/95  7:16:43 AM
0.44
545.60
960
5/11/95  11:36:33 PM
0.44
422.40
520
5/15/95  11:29:26 PM
0.44
228.80
120
5/20/95  1:42:18 AM
0.44
52.80
240
5/26/95  8:38:27 PM
0.44
105.60
1.040
5/27/95  10:10:48 PM
0.44
457.60
240
6/6/95  4:23:12 PM
0.44
105.60
600
6/9/95  5:23:49 PM
0.44
264.00
1.080
6/10/95  2:18:51 AM
0.44
475.20
1.320
6/13/95  4:25:51 AM
0.44
580.80
9.920
4,364.80
07.95
1.120
7/19/95  3:05:34 AM
0.44
492.80
160
8/12/95  1:54:47 AM
0.44
70.40
400
8/13/95  10:02:16 PM
0.44
176.00
120
8/18/95  4:39:28 AM
0.44
52.80
680
9/7/95  10:48:56 AM
0.44
299.20
1.240
9/19/95  5:45:14 PM
0.44
545.60
3.720
1,636.80
10.95
1.200
10/5/95  2:41:45 AM
0.44
528.00
1.280
10/5/95  9:02:43 AM
0.44
563.20
320
10/17/95  10:36:40 PM
0.44
140.80
120
10/18/95  3:26:47 PM
0.44
52.80
920
11/21/95  6:21:18 PM
0.44
404.80
480
11/22/95  6:51:26 PM
0.44
211.20
1.160
12/8/95  7:03:07 PM
0.44
510.40
1.040
12/26/95  9:10:54 AM
0.44
457.60
6.520
2,868.80

01.95
Burl's Bananas
480
1/12/95  8:34:35 AM
0.68
326.40
920
1/17/95  7:42:06 PM
0.68
625.60
240
1/19/95  10:35:54 AM
0.68
163.20
1.240
2/6/95  4:07:52 AM
0.68
843.20
120
2/9/95  9:29:19 PM
0.68
81.60
400
2/10/95  3:10:55 AM
0.68
272.00
400
2/10/95  5:57:44 PM
0.68
272.00
1.360
2/13/95  8:47:57 AM
0.68
924.80
1.080
2/24/95  2:18:54 PM
0.68
734.40
520
3/8/95  4:05:44 PM
0.68
353.60
200
3/21/95  8:42:08 PM
0.68
136.00
160
3/25/95  8:34:40 PM
0.68
108.80
7.120
4,841.60

© 2005-2024, i-net software GmbH
Page 2

Quarter
Quantity
Product
OrderDate
Unit Price
Price
04.95
Burl's Bananas
160
4/2/95  1:51:08 PM
0.68
108.80
560
4/4/95  7:21:09 AM
0.68
380.80
1.200
4/7/95  6:43:44 PM
0.68
816.00
440
4/7/95  8:49:57 PM
0.68
299.20
280
4/10/95  5:07:28 AM
0.68
190.40
240
4/15/95  8:54:25 AM
0.68
163.20
1.240
4/22/95  2:37:57 PM
0.68
843.20
440
4/24/95  9:37:28 PM
0.68
299.20
1.120
5/7/95  6:12:11 PM
0.68
761.60
400
5/18/95  10:24:12 PM
0.68
272.00
360
5/20/95  6:44:40 PM
0.68
244.80
1.000
6/6/95  5:32:39 AM
0.68
680.00
1.360
6/8/95  4:10:09 PM
0.68
924.80
1.200
6/9/95  11:00:36 AM
0.68
816.00
760
6/11/95  5:40:48 PM
0.68
516.80
1.000
6/19/95  7:31:15 PM
0.68
680.00
920
6/27/95  5:57:03 PM
0.68
625.60
12.680
8,622.40
07.95
800
7/11/95  7:10:13 AM
0.68
544.00
1.240
7/15/95  4:38:38 PM
0.68
843.20
880
7/15/95  4:48:11 PM
0.68
598.40
880
7/16/95  12:07:25 PM
0.68
598.40
80
8/3/95  1:53:16 AM
0.68
54.40
280
8/7/95  3:26:15 AM
0.68
190.40
1.160
8/9/95  2:53:33 AM
0.68
788.80
280
8/9/95  8:28:41 AM
0.68
190.40
1.320
8/15/95  7:21:44 AM
0.68
897.60
1.360
8/22/95  1:37:05 PM
0.68
924.80
1.200
8/24/95  11:20:44 PM
0.68
816.00
840
8/28/95  11:23:52 AM
0.68
571.20
800
9/2/95  9:30:25 AM
0.68
544.00
880
9/4/95  10:31:20 AM
0.68
598.40
1.240
9/12/95  4:12:08 AM
0.68
843.20
920
9/13/95  11:53:46 PM
0.68
625.60
14.160
9,628.80
10.95
200
10/6/95  9:55:38 PM
0.68
136.00
1.080
10/11/95  4:19:46 PM
0.68
734.40
1.000
10/14/95  8:55:03 AM
0.68
680.00
1.120
10/21/95  10:42:40 PM
0.68
761.60
880
10/22/95  10:14:51 PM
0.68
598.40
160
10/22/95  11:19:02 PM
0.68
108.80
800
10/25/95  2:24:33 PM
0.68
544.00
960
11/7/95  1:27:59 AM
0.68
652.80
1.160
11/8/95  10:48:27 PM
0.68
788.80
1.000
11/18/95  6:20:32 PM
0.68
680.00

© 2005-2024, i-net software GmbH
Page 3

Quarter
Quantity
Product
OrderDate
Unit Price
Price
760
11/18/95  7:41:02 PM
0.68
516.80
1.160
11/23/95  12:19:18 AM
0.68
788.80
720
11/23/95  5:35:53 AM
0.68
489.60
1.280
12/18/95  3:34:28 AM
0.68
870.40
920
12/23/95  10:16:43 PM
0.68
625.60
13.200
8,976.00

01.95
Demetrius' Lima Beans
680
1/14/95  11:06:24 PM
2.17
1,475.60
240
1/28/95  4:35:25 PM
2.17
520.80
720
2/4/95  4:04:05 PM
2.17
1,562.40
1.280
2/11/95  4:06:01 AM
2.17
2,777.60
320
2/12/95  7:15:17 AM
2.17
694.40
120
2/15/95  10:07:56 AM
2.17
260.40
240
2/20/95  10:29:37 AM
2.17
520.80
760
2/26/95  7:51:01 AM
2.17
1,649.20
1.280
2/26/95  11:30:38 AM
2.17
2,777.60
760
3/4/95  7:51:02 PM
2.17
1,649.20
800
3/14/95  6:06:58 PM
2.17
1,736.00
7.200
15,624.00
04.95
840
4/5/95  3:35:39 AM
2.17
1,822.80
680
4/14/95  9:22:23 AM
2.17
1,475.60
1.280
4/19/95  6:53:29 AM
2.17
2,777.60
760
4/19/95  8:34:28 AM
2.17
1,649.20
1.000
4/19/95  11:48:02 PM
2.17
2,170.00
720
4/23/95  9:13:38 PM
2.17
1,562.40
800
4/28/95  5:22:50 PM
2.17
1,736.00
640
5/3/95  4:26:58 AM
2.17
1,388.80
840
5/4/95  2:27:19 PM
2.17
1,822.80
960
5/7/95  10:22:28 PM
2.17
2,083.20
200
5/12/95  9:10:33 AM
2.17
434.00
480
5/16/95  12:09:47 PM
2.17
1,041.60
920
5/17/95  9:29:28 AM
2.17
1,996.40
440
5/21/95  9:06:17 PM
2.17
954.80
1.400
5/26/95  6:53:31 AM
2.17
3,038.00
400
6/20/95  1:18:26 AM
2.17
868.00
12.360
26,821.20
07.95
1.120
7/5/95  11:21:30 AM
2.17
2,430.40
400
7/23/95  8:29:51 AM
2.17
868.00
600
8/2/95  8:36:00 PM
2.17
1,302.00
1.240
8/20/95  8:10:29 AM
2.17
2,690.80
200
8/23/95  1:41:14 AM
2.17
434.00
1.040
8/27/95  5:12:57 PM
2.17
2,256.80
1.360
8/28/95  7:52:33 PM
2.17
2,951.20
560
9/25/95  11:20:34 PM
2.17
1,215.20
6.520
14,148.40
10.95

© 2005-2024, i-net software GmbH
Page 4

Quarter
Quantity
Product
OrderDate
Unit Price
Price
760
10/9/95  10:57:17 AM
2.17
1,649.20
240
10/17/95  11:03:04 PM
2.17
520.80
720
10/19/95  11:20:35 PM
2.17
1,562.40
480
10/21/95  3:28:51 AM
2.17
1,041.60
280
10/21/95  2:23:57 PM
2.17
607.60
80
10/21/95  9:52:19 PM
2.17
173.60
1.240
11/3/95  5:31:14 AM
2.17
2,690.80
920
11/15/95  8:40:27 AM
2.17
1,996.40
280
11/17/95  6:54:30 PM
2.17
607.60
600
11/19/95  4:09:46 AM
2.17
1,302.00
280
11/24/95  6:01:19 PM
2.17
607.60
1.160
12/25/95  11:55:56 PM
2.17
2,517.20
7.040
15,276.80

© 2005-2024, i-net software GmbH
Page 5