Spreadsheet: 191603d1352151643-pivot-table-p-mix-sample
Sheet: P-Mix Sample

Item number | Name | unit sold | dollar each | dollar total
2001 | Name | 175 | 3.44 | 602 | 0 | 602 | 0 | 0.23
2001 | Name | 43 | 3.44 | 147.92 | 0 | 147.92 | 0 | 0.06
2002 | Name | 272 | 3.87 | 1052.64 | 0 | 1052.64 | 0 | 0.4
2002 | Name | 58 | 3.87 | 224.46 | 0 | 224.46 | 0 | 0.09
2003 | Name | 49 | 3.87 | 189.63 | 0 | 189.63 | 0 | 0.07
2003 | Name | 11 | 3.87 | 42.57 | 0 | 42.57 | 0 | 0.02
2004 | Name | 151 | 3.44 | 519.44 | 0 | 519.44 | 0 | 0.2
2004 | Name | 25 | 3.44 | 86 | 0 | 86 | 0 | 0.03
2005 | Name | 126 | 3.87 | 487.62 | 0 | 487.62 | 0 | 0.19
2005 | Name | 18 | 3.87 | 69.66 | 0 | 69.66 | 0 | 0.03
2006 | Name | 203 | 3.87 | 785.61 | 0 | 785.61 | 0 | 0.3
2006 | Name | 55 | 3.87 | 212.85 | 0 | 212.85 | 0 | 0.08
2007 | Name | 3 | 3.87 | 11.61 | 0 | 11.61 | 0 | 0
2007 | Name | 1 | 3.87 | 3.87 | 0 | 3.87 | 0 | 0
2008 | Name | 131 | 3.87 | 506.97 | 0 | 506.97 | 0 | 0.19
2008 | Name | 24 | 3.87 | 92.88 | 0 | 92.88 | 0 | 0.04
2009 | Name | 169 | 3.87 | 654.03 | 0 | 654.03 | 0 | 0.25
2009 | Name | 27 | 3.87 | 104.49 | 0 | 104.49 | 0 | 0.04
2011 | Name | 21 | 1.29 | 27.09 | 0 | 27.09 | 0 | 0.01
2011 | Name | 8 | 1.29 | 10.32 | 0 | 10.32 | 0 | 0
2013 | Name | 152 | 3.87 | 588.24 | 0 | 588.24 | 0 | 0.23
2013 | Name | 44 | 3.87 | 170.28 | 0 | 170.28 | 0 | 0.07
2017 | Name | 123 | 3.44 | 423.12 | 0 | 423.12 | 0 | 0.16
2017 | Name | 24 | 3.44 | 82.56 | 0 | 82.56 | 0 | 0.03
2018 | Name | 71 | 3.87 | 274.77 | 0 | 274.77 | 0 | 0.11
2018 | Name | 14 | 3.87 | 54.18 | 0 | 54.18 | 0 | 0.02
3054 | Name | 106 | 8.6 | 911.6 | 0 | 911.6 | 0 | 0.35
3054 | Name | 27 | 8.6 | 232.2 | 0 | 232.2 | 0 | 0.09
3055 | Name | 161 | 6.02 | 969.22 | 0 | 969.22 | 0 | 0.37
3055 | Name | 47 | 6.02 | 282.94 | 0 | 282.94 | 0 | 0.11
3056 | Name | 11 | 10.32 | 113.52 | 0 | 113.52 | 0 | 0.04
3056 | Name | 3 | 10.32 | 30.96 | 0 | 30.96 | 0 | 0.01
3057 | Name | 39 | 6.02 | 234.78 | 0 | 234.78 | 0 | 0.09
3057 | Name | 4 | 6.02 | 24.08 | 0 | 24.08 | 0 | 0.01
3059 | Name | 16 | 6.02 | 96.32 | 0 | 96.32 | 0 | 0.04
3059 | Name | 2 | 6.02 | 12.04 | 0 | 12.04 | 0 | 0
3060 | Name | 77 | 6.02 | 463.54 | 0 | 463.54 | 0 | 0.18
3060 | Name | 25 | 6.02 | 150.5 | 0 | 150.5 | 0 | 0.06
3061 | Name | 16 | 10.32 | 165.12 | 0 | 165.12 | 0 | 0.06
3062 | Name | 34 | 6.88 | 233.92 | 0 | 233.92 | 0 | 0.09
3062 | Name | 7 | 6.88 | 48.16 | 0 | 48.16 | 0 | 0.02
3063 | Name | 23 | 10.32 | 237.36 | 0 | 237.36 | 0 | 0.09
3064 | Name | 1 | 24.08 | 24.08 | 0 | 24.08 | 0 | 0.01
3071 | Name | 2 | 27.52 | 55.04 | 0 | 55.04 | 0 | 0.02
3072 | Name | 2 | 41.28 | 82.56 | 0 | 82.56 | 0 | 0.03
3073 | Name | 53 | 7.74 | 410.22 | 0 | 410.22 | 0 | 0.16
3073 | Name | 18 | 7.74 | 139.32 | 0 | 139.32 | 0 | 0.05
3074 | Name | 1 | 28.38 | 28.38 | 0 | 28.38 | 0 | 0.01
4007 | Name | 4 | 10.32 | 41.28 | 0 | 41.28 | 0 | 0.02
4008 | Name | 1 | 9.46 | 9.46 | 0 | 9.46 | 0 | 0
4012 | Name | 2 | 10.32 | 20.64 | 0 | 20.64 | 0 | 0.01
4013 | Name | 2 | 8.6 | 17.2 | 0 | 17.2 | 0 | 0.01
4014 | Name | 2 | 8.6 | 17.2 | 0 | 17.2 | 0 | 0.01
4015 | Name | 1 | 8.6 | 8.6 | 0 | 8.6 | 0 | 0
4017 | Name | 3 | 38.7 | 116.1 | 0 | 116.1 | 0 | 0.04
4018 | Name | 38 | 6.88 | 261.44 | 0 | 261.44 | 0 | 0.1
4018 | Name | 10 | 6.88 | 68.8 | 0 | 68.8 | 0 | 0.03
4019 | Name | 21 | 7.74 | 162.54 | 0 | 162.54 | 0 | 0.06
4019 | Name | 8 | 7.74 | 61.92 | 0 | 61.92 | 0 | 0.02
4023 | Name | 68 | 7.74 | 526.32 | 0 | 526.32 | 0 | 0.2
4023 | Name | 25 | 7.74 | 193.5 | 0 | 193.5 | 0 | 0.07
4025 | Name | 7 | 7.74 | 54.18 | 0 | 54.18 | 0 | 0.02
4027 | Name | 3 | 1.51 | 4.52 | 0 | 4.52 | 0 | 0
4029 | Name | 13 | 6.88 | 89.44 | 0 | 89.44 | 0 | 0.03
4029 | Name | 6 | 6.88 | 41.28 | 0 | 41.28 | 0 | 0.02
4031 | Name | 2 | 7.74 | 15.48 | 0 | 15.48 | 0 | 0.01
4033 | Name | 6 | 7.74 | 46.44 | 0 | 46.44 | 0 | 0.02
4033 | Name | 2 | 7.74 | 15.48 | 0 | 15.48 | 0 | 0.01
4034 | Name | 4 | 7.74 | 30.96 | 0 | 30.96 | 0 | 0.01
4036 | Name | 1 | 7.74 | 7.74 | 0 | 7.74 | 0 | 0
4039 | Name | 1 | 7.74 | 7.74 | 0 | 7.74 | 0 | 0
4040 | Name | 2 | 7.74 | 15.48 | 0 | 15.48 | 0 | 0.01
4040 | Name | 3 | 7.74 | 23.22 | 0 | 23.22 | 0 | 0.01
4042 | Name | 2 | 7.74 | 15.48 | 0 | 15.48 | 0 | 0.01
4043 | Name | 3 | 6.88 | 20.64 | 0 | 20.64 | 0 | 0.01
4044 | Name | 12 | 7.74 | 92.88 | 0 | 92.88 | 0 | 0.04
4045 | Name | 12 | 6.88 | 82.56 | 0 | 82.56 | 0 | 0.03
4045 | Name | 1 | 6.88 | 6.88 | 0 | 6.88 | 0 | 0
4048 | Name | 47 | 7.74 | 363.78 | 0 | 363.78 | 0 | 0.14
4049 | Name | 26 | 7.74 | 201.24 | 0 | 201.24 | 0 | 0.08
4049 | Name | 5 | 7.74 | 38.7 | 0 | 38.7 | 0 | 0.01
4050 | Name | 24 | 7.74 | 185.76 | 0 | 185.76 | 0 | 0.07
4052 | Name | 14 | 7.74 | 108.36 | 0 | 108.36 | 0 | 0.04
4056 | Name | 1 | 7.74 | 7.74 | 0 | 7.74 | 0 | 0
4056 | Name | 5 | 7.74 | 38.7 | 0 | 38.7 | 0 | 0.01
4057 | Name | 102 | 8.6 | 877.2 | 0 | 877.2 | 0 | 0.34
4057 | Name | 33 | 8.6 | 283.8 | 0 | 283.8 | 0 | 0.11
4058 | Name | 1684 | 6.88 | 11585.93 | 0 | 11585.93 | 0 | 4.43
4058 | Name | 494 | 6.88 | 3398.72 | 0 | 3398.72 | 0 | 1.3
4059 | Name | 160 | 8.6 | 1376 | 0 | 1376 | 0 | 0.53
4059 | Name | 39 | 8.6 | 335.4 | 0 | 335.4 | 0 | 0.13
4060 | Name | 10 | 10.32 | 103.2 | 0 | 103.2 | 0 | 0.04
4060 | Name | 1 | 10.32 | 10.32 | 0 | 10.32 | 0 | 0
4061 | Name | 838 | 6.88 | 5765.44 | 0 | 5765.44 | 0 | 2.21
4061 | Name | 222 | 6.88 | 1527.36 | 0 | 1527.36 | 0 | 0.58
4062 | Name | 974 | 6.88 | 6701.12 | 0 | 6701.12 | 0 | 2.56
4062 | Name | 258 | 6.88 | 1775.04 | 0 | 1775.04 | 0 | 0.68
4063 | Name | 32 | 8.6 | 275.2 | 0 | 275.2 | 0 | 0.11
4063 | Name | 5 | 8.6 | 43 | 0 | 43 | 0 | 0.02
4068 | Name | 2 | 8.6 | 17.2 | 0 | 17.2 | 0 | 0.01
4070 | Name | 1 | 8.6 | 8.6 | 0 | 8.6 | 0 | 0
4072 | Name | 117 | 8.6 | 1006.2 | 0 | 1006.2 | 0 | 0.39
4072 | Name | 43 | 8.6 | 369.8 | 0 | 369.8 | 0 | 0.14
4079 | Name | 1 | 7.74 | 7.74 | 0 | 7.74 | 0 | 0
4083 | Name | 18 | 8.6 | 154.8 | 0 | 154.8 | 0 | 0.06
4083 | Name | 13 | 8.6 | 111.8 | 0 | 111.8 | 0 | 0.04
4088 | Name | 1 | 6.88 | 6.88 | 0 | 6.88 | 0 | 0
4091 | Name | 8 | 7.74 | 61.92 | 0 | 61.92 | 0 | 0.02
4091 | Name | 1 | 7.74 | 7.74 | 0 | 7.74 | 0 | 0
4095 | Name | 2 | 7.74 | 15.48 | 0 | 15.48 | 0 | 0.01
4101 | Name | 7 | 6.88 | 48.16 | 0 | 48.16 | 0 | 0.02
4102 | Name | 2 | 10.32 | 20.64 | 0 | 20.64 | 0 | 0.01
4106 | Name | 3 | 8.6 | 25.8 | 0 | 25.8 | 0 | 0.01
4108 | Name | 5 | 7.74 | 38.7 | 0 | 38.7 | 0 | 0.01
4108 | Name | 5 | 7.74 | 38.7 | 0 | 38.7 | 0 | 0.01
4111 | Name | 3 | 4.3 | 12.9 | 0 | 12.9 | 0 | 0
4111 | Name | 1 | 4.3 | 4.3 | 0 | 4.3 | 0 | 0.04
4125 | Name | 1 | 7.74 | 7.74 | 0 | 7.74 | 0 | 0
4135 | Name | 3 | 7.74 | 23.22 | 0 | 23.22 | 0 | 0.01
4140 | Name | 1 | 7.74 | 7.74 | 0 | 7.74 | 0 | 0
4141 | Name | 2 | 7.74 | 15.48 | 0 | 15.48 | 0 | 0.01
4145 | Name | 32 | 10.32 | 330.24 | 0 | 330.24 | 0 | 0.13
4145 | Name | 10 | 10.32 | 103.2 | 0 | 103.2 | 0 | 0.04
4161 | Name | 41 | 8.6 | 352.6 | 0 | 352.6 | 0 | 0.13
4161 | Name | 21 | 8.6 | 180.6 | 0 | 180.6 | 0 | 0.07
4163 | Name | 360 | 10.32 | 3715.2 | 0 | 3715.2 | 0 | 1.42
4163 | Name | 74 | 10.32 | 763.68 | 0 | 763.68 | 0 | 0.29
4166 | Name | 11 | 10.32 | 113.52 | 0 | 113.52 | 0 | 0.04
4167 | Name | 3 | 10.32 | 30.96 | 0 | 30.96 | 0 | 0.01
4168 | Name | 1 | 10.32 | 10.32 | 0 | 10.32 | 0 | 0
4171 | Name | 1 | 10.32 | 10.32 | 0 | 10.32 | 0 | 0
4172 | Name | 41 | 10.32 | 423.12 | 0 | 423.12 | 0 | 0.16
4172 | Name | 5 | 10.32 | 51.6 | 0 | 51.6 | 0 | 0.02
4173 | Name | 2 | 10.32 | 20.64 | 0 | 20.64 | 0 | 0.01
4206 | Name | 3 | 8.6 | 25.8 | 0 | 25.8 | 0 | 0.01
4211 | Name | 2 | 9.46 | 18.92 | 0 | 18.92 | 0 | 0.01
4213 | Name | 3 | 6.88 | 20.64 | 0 | 20.64 | 0 | 0.01
4214 | Name | 1 | 8.6 | 8.6 | 0 | 8.6 | 0 | 0
4223 | Name | 96 | 8.6 | 825.6 | 0 | 825.6 | 0 | 0.32
4223 | Name | 27 | 8.6 | 232.2 | 0 | 232.2 | 0 | 0.09
4224 | Name | 13 | 7.74 | 100.62 | 0 | 100.62 | 0 | 0.04
4224 | Name | 1 | 7.74 | 7.74 | 0 | 7.74 | 0 | 0
4225 | Name | 57 | 8.6 | 490.2 | 0 | 490.2 | 0 | 0.19
4225 | Name | 4 | 8.6 | 34.4 | 0 | 34.4 | 0 | 0.01
4231 | Name | 3 | 10.32 | 30.96 | 0 | 30.96 | 0 | 0.01
4234 | Name | 1 | 10.32 | 10.32 | 0 | 10.32 | 0 | 0
4235 | Name | 3 | 8.6 | 25.8 | 0 | 25.8 | 0 | 0.01
4236 | Name | 182 | 6.88 | 1252.16 | 0 | 1252.16 | 0 | 0.48
4236 | Name | 55 | 6.88 | 378.4 | 0 | 378.4 | 0 | 0.14
4237 | Name | 23 | 8.6 | 197.8 | 0 | 197.8 | 0 | 0.08
4237 | Name | 1 | 8.6 | 8.6 | 0 | 8.6 | 0 | 0
4669 | Name | 3 | 8.6 | 25.8 | 0 | 25.8 | 0 | 0.01
4675 | Name | 2 | 6.88 | 13.76 | 0 | 13.76 | 0 | 0.01
13167 | Name | 4 | 0 | 0 | 0 | 0 | 0 | 14.81
13190 | Name | 5 | 0 | 0 | 0 | 0 | 0 | 14.81
13193 | Name | 25 | 0 | 0 | 0 | 0 | 0 | 14.81
13194 | Name | 49 | 0 | 0 | 0 | 0 | 0 | 14.81
13194 | Name | 19 | 0 | 0 | 0 | 0 | 0 | 3.9
13196 | Name | 1 | 0 | 0 | 0 | 0 | 0 | 14.81
13198 | Name | 4 | 0 | 0 | 0 | 0 | 0 | 14.81
13198 | Name | 2 | 0 | 0 | 0 | 0 | 0 | 3.9
13200 | Name | 1 | 0 | 0 | 0 | 0 | 0 | 14.81
13223 | Name | 10 | 0 | 0 | 0 | 0 | 0 | 14.81
13224 | Name | 6 | 0 | 0 | 0 | 0 | 0 | 14.81
13225 | Name | 9 | 0 | 0 | 0 | 0 | 0 | 14.81
13225 | Name | 2 | 0 | 0 | 0 | 0 | 0 | 3.9
13226 | Name | 57 | 0 | 0 | 0 | 0 | 0 | 14.81
13226 | Name | 8 | 0 | 0 | 0 | 0 | 0 | 3.9
13227 | Name | 4 | 0 | 0 | 0 | 0 | 0 | 14.81
13228 | Name | 1 | 0 | 0 | 0 | 0 | 0 | 14.81
13231 | Name | 2 | 0 | 0 | 0 | 0 | 0 | 14.81
13231 | Name | 11 | 0 | 0 | 0 | 0 | 0 | 3.9
13232 | Name | 2 | 0 | 0 | 0 | 0 | 0 | 14.81
13233 | Name | 142 | 0 | 0 | 0 | 0 | 0 | 14.81
13233 | Name | 29 | 0 | 0 | 0 | 0 | 0 | 3.9
13234 | Name | 16 | 0 | 0 | 0 | 0 | 0 | 14.81
13235 | Name | 1 | 0 | 0 | 0 | 0 | 0 | 14.81
13239 | Name | 6 | 0 | 0 | 0 | 0 | 0 | 14.81
13239 | Name | 5 | 0 | 0 | 0 | 0 | 0 | 3.9
13263 | Name | 20 | 0 | 0 | 0 | 0 | 0 | 14.81
13263 | Name | 2 | 0 | 0 | 0 | 0 | 0 | 3.9
13264 | Name | 3 | 0 | 0 | 0 | 0 | 0 | 14.81
13285 | Name | 2 | 0 | 0 | 0 | 0 | 0 | 14.81