Excel2016_Pivot_Practice.xlsx

	A	B	C	D	E
1	Salesperson	Region	Account	Order Amount	Term
2	Albertson, Kathy	East	29386	$925.00	January
3	Albertson, Kathy	East	74830	$875.00	February
4	Albertson, Kathy	East	90099	$500.00	February
5	Albertson, Kathy	East	74830	$350.00	March
6	Brennan, Michael	West	82853	$400.00	January
7	Brennan, Michael	West	72949	$850.00	January
8	Brennan, Michael	West	90044	$1,500.00	January
9	Brennan, Michael	West	82853	$550.00	February
10	Brennan, Michael	West	72949	$400.00	March
11	Davis, William	South	55223	$235.00	February
12	Davis, William	South	10354	$850.00	January
13	Davis, William	South	50192	$600.00	March
14	Davis, William	South	27589	$250.00	January
15	Dumlao, Richard	West	67275	$400.00	January
16	Dumlao, Richard	West	41828	$965.00	February
17	Dumlao, Richard	West	87543	$125.00	March
18	Flores, Tia	South	97446	$1,500.00	March
19	Flores, Tia	South	41400	$305.00	January
20	Flores, Tia	South	30974	$1,350.00	January
21	Flores, Tia	South	41400	$435.00	February
22	Flores, Tia	South	30974	$550.00	February
23	Flores, Tia	South	30974	$425.00	March
24	Post, Melissa	East	78532	$765.00	January
25	Post, Melissa	East	78532	$150.00	February
26	Post, Melissa	East	65532	$425.00	February
27	Post, Melissa	East	78532	$350.00	March
28	Thompson, Shannon	North	91987	$875.00	January
29	Thompson, Shannon	North	91041	$265.00	January
30	Thompson, Shannon	North	91987	$375.00	February
31	Thompson, Shannon	North	91041	$1,345.00	February
32	Thompson, Shannon	North	91987	$300.00	March
33	Walters, Chris	South	55667	$225.00	January
34	Walters, Chris	South	54393	$105.00	January
35	Walters, Chris	South	40028	$25.00	January
36	Walters, Chris	South	55667	$155.00	February
37	Walters, Chris	South	54393	$2,600.00	February
38	Walters, Chris	South	54393	$225.00	March
39	Walters, Chris	South	55667	$785.00	March
40	Walters, Chris	South	27589	$255.00	March
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100