pivot table calculated items and fields.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1			Branch	Values
2			East		North		South		West		Grand Total
3	Type	Product Category	Sales	Tax	Sales	Tax	Sales	Tax	Sales	Tax	Sales	Tax
4	Cash	Electronics	19,866	#NAME?	46,419	#NAME?	69,513	#NAME?	45,876	#NAME?	181,674	#NAME?
5		Hardware	28,216	#NAME?	44,167	#NAME?	75,118	#NAME?	80,490	#NAME?	227,991	#NAME?
6	Cash Total		48,082	#NAME?	90,586	#NAME?	144,631	#NAME?	126,366	#NAME?	409,665	#NAME?
7	Credit	Electronics	89,837	#NAME?	41,839	#NAME?	96,352	#NAME?	48,217	#NAME?	276,245	#NAME?
8		Hardware	63,720	#NAME?	16,583	#NAME?	82,507	#NAME?	22,053	#NAME?	184,863	#NAME?
9	Credit Total		153,557	#NAME?	58,422	#NAME?	178,859	#NAME?	70,270	#NAME?	461,108	#NAME?
10	Grand Total		201,639	#NAME?	149,008	#NAME?	323,490	#NAME?	196,636	#NAME?	870,773	#NAME?
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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