java LocationRollUp city 3 0 city , Number of Sales , Total number of sold items , Total $$ made Los Angeles 39498 118461 475657.72 San Luis Obispo 13538 40807 166726.35 Stockton 13544 40952 165119.12 Tucson 13497 40639 164667.58 Seattle 13373 40101 163816.03 Olympia 13442 40291 163477.54 Monterey 13482 40166 163160.48 San Jose 13380 39897 162933.34 Flagstaff 13258 39887 162573.07 San Francisco 13428 40328 162473.51 Reno 13412 40371 162424.14 Las Vegas 13338 39949 161857.56 Sacramento 13105 39353 160459.09 Phoenix 13172 39425 160344.22 San Diego 13260 39949 160132.73 Bakersfield 13244 39654 160118.96 Santa Barbara 12953 38792 157044.82 Portland 13285 39728 156728.51 java LocationRollUp zip 2 1 a zip , AVG Number of Sales , AVG number of sold items , AVG $$ made 93108 12953 38792 157044.82 90081 13102 39344 157344.25 94211 13105 39353 160459.09 85016 13172 39425 160344.22 90001 13198 39558.5 159156.73 93308 13244 39654 160118.96 97209 13285 39728 156728.51 86001 13258 39887 162573.07 95106 13380 39897 162933.34 89101 13338 39949 161857.56 92110 13260 39949 160132.73 98111 13373 40101 163816.03 93943 13482 40166 163160.48 98512 13442 40291 163477.54 94171 13428 40328 162473.51 89507 13412 40371 162424.14 85701 13497 40639 164667.58 93405 13538 40807 166726.35 95208 13544 40952 165119.12 java LocationRollUp location 1 0 d Store , Number of Sales , Total number of sold items , Total $$ made 12 13544 40952 165119.12 2 13538 40807 166726.35 20 13497 40639 164667.58 9 13482 40166 163160.48 15 13442 40291 163477.54 1 13428 40328 162473.51 16 13412 40371 162424.14 7 13380 39897 162933.34 14 13373 40101 163816.03 17 13338 39949 161857.56 4 13291 40136 161080.99 13 13285 39728 156728.51 6 13260 39949 160132.73 19 13258 39887 162573.07 10 13244 39654 160118.96 18 13172 39425 160344.22 5 13105 38981 157232.48 11 13105 39353 160459.09 3 13102 39344 157344.25 8 12953 38792 157044.82 java LocationRollUpSlice location item Chocolate Cake 2 0 d Store , Number of Sales , Total number of sold items , Total $$ made 12 13544 40952 165119.12 2 13538 40807 166726.35 20 13497 40639 164667.58 16 13412 40371 162424.14 1 13428 40328 162473.51 15 13442 40291 163477.54 9 13482 40166 163160.48 4 13291 40136 161080.99 14 13373 40101 163816.03 6 13260 39949 160132.73 17 13338 39949 161857.56 7 13380 39897 162933.34 19 13258 39887 162573.07 13 13285 39728 156728.51 10 13244 39654 160118.96 18 13172 39425 160344.22 11 13105 39353 160459.09 3 13102 39344 157344.25 5 13105 38981 157232.48 8 12953 38792 157044.82 java LocationRollUpSlice state type Drink 1 1 state , AVG Number of Sales , AVG number of sold items , AVG $$ made OR 2869 8621 21199.59 AZ 2853.66 8559.66 21198.59 NV 2850 8572.5 21088.73 CA 2840.58 8540.75 21129.36 WA 2835.5 8545 21049.73 java LocationRollUpSlice zip Food Cookie 3 0 a zip , Number of Sales , Total number of sold items , Total $$ made 97209 13285 39728 156728.51 93108 12953 38792 157044.82 90081 13102 39344 157344.25 93308 13244 39654 160118.96 92110 13260 39949 160132.73 85016 13172 39425 160344.22 94211 13105 39353 160459.09 89101 13338 39949 161857.56 89507 13412 40371 162424.14 94171 13428 40328 162473.51 86001 13258 39887 162573.07 95106 13380 39897 162933.34 93943 13482 40166 163160.48 98512 13442 40291 163477.54 98111 13373 40101 163816.03 85701 13497 40639 164667.58 95208 13544 40952 165119.12 93405 13538 40807 166726.35 90001 26396 79117 318313.47 java TimeRollUp month location 0 0 d Month , location , Number of Sales , Total number of sold items , Total $$ made 12 1 1214 3683 15068.82 11 1 1140 3384 14232.91 10 1 1246 3694 14665.13 09 1 1045 3093 12315.3 08 1 1163 3535 13589.4 07 1 1026 3062 12296.18 06 1 1045 3206 13742.6 05 1 1059 3274 13204.28 04 1 1143 3433 13116.33 03 1 1081 3266 14424.3 02 1 1146 3426 12893.1 01 1 1120 3272 12925.16 01 2 13538 40807 166726.35 01 3 13102 39344 157344.25 01 4 13291 40136 161080.99 01 5 13105 38981 157232.48 01 6 13260 39949 160132.73 01 7 13380 39897 162933.34 01 8 12953 38792 157044.82 01 9 13482 40166 163160.48 01 10 13244 39654 160118.96 01 11 13105 39353 160459.09 01 12 13544 40952 165119.12 01 13 13285 39728 156728.51 01 14 13373 40101 163816.03 01 15 13442 40291 163477.54 01 16 13412 40371 162424.14 01 17 13338 39949 161857.56 01 18 13172 39425 160344.22 01 19 13258 39887 162573.07 01 20 13497 40639 164667.58 java TimeRollUp day state 0 1 d Day , state , AVG Number of Sales , AVG number of sold items , AVG $$ made 29 AZ 13289.48 39946.67 162545.44 29 CA 13341.51 40120.86 161990.95 29 NV 13354.81 40044.90 161986.33 29 OR 13285 39728 156728.51 29 WA 13407.5 40196 163646.78 28 AZ 13288.13 39941.60 162527.25 28 CA 13337.05 40102.39 161955.7 28 NV 13353.88 40039.55 161979.14 28 OR 13285 39728 156728.51 28 WA 13407.5 40196 163646.78 27 AZ 13290.41 39948.44 162544.62 27 CA 13340.24 40114.50 162002.58 27 NV 13354.01 40040.34 161980.22 27 OR 13285 39728 156728.51 27 WA 13407.5 40196 163646.78 26 AZ 13288.97 39945.70 162545.88 26 CA 13344.58 40128.35 162037.25 26 NV 13353.54 40037.65 161976.58 26 OR 13285 39728 156728.51 26 WA 13407.5 40196 163646.78 25 AZ 13290.28 39948.18 162544.72 25 CA 13343.98 40125.63 162061.28 25 NV 13354.08 40040.74 161980.72 25 OR 13285 39728 156728.51 25 WA 13407.5 40196 163646.78 24 AZ 13289.48 39946.67 162545.44 24 CA 13342.97 40121.31 161999.86 24 NV 13355.05 40046.23 161988.1 24 OR 13285 39728 156728.51 24 WA 13407.5 40196 163646.78 23 AZ 13289.87 39947.41 162545.08 23 CA 13342.12 40119.27 162023.78 23 NV 13353.88 40039.55 161979.14 23 OR 13285 39728 156728.51 23 WA 13407.5 40196 163646.78 22 AZ 13289.87 39947.41 162545.08 22 CA 13342.61 40122.32 162031.92 22 NV 13353.88 40039.55 161979.14 22 OR 13285 39728 156728.51 22 WA 13407.5 40196 163646.78 21 AZ 13289.35 39946.42 162545.55 21 CA 13342.92 40126.67 162041.62 21 NV 13353.74 40038.79 161978.12 21 OR 13285 39728 156728.51 21 WA 13407.5 40196 163646.78 20 AZ 13291.55 39950.59 162543.61 20 CA 13344.31 40127.54 162032.33 20 NV 13353.67 40038.40 161977.6 20 OR 13285 39728 156728.51 20 WA 13407.85 40196.95 163645.08 19 AZ 13289.61 39946.91 162545.31 19 CA 13346.50 40131.00 162074.05 19 NV 13354.59 40043.62 161984.6 19 OR 13285 39728 156728.51 19 WA 13407.5 40196 163646.78 18 AZ 13289.61 39946.91 162545.31 18 CA 13340.46 40118.7 162003.77 18 NV 13354.22 40041.54 161981.81 18 OR 13285 39728 156728.51 18 WA 13407.5 40196 163646.78 17 AZ 13290.1 39949.08 162554.44 17 CA 13343.02 40119.41 162020.39 17 NV 13354.37 40042.36 161982.9 17 OR 13285 39728 156728.51 17 WA 13407.5 40196 163646.78 16 AZ 13289.09 39945.94 162545.77 16 CA 13342.51 40120.20 161998.53 16 NV 13354.94 40045.63 161987.3 16 OR 13285 39728 156728.51 16 WA 13407.5 40196 163646.78 15 AZ 13289.22 39946.18 162545.66 15 CA 13343.94 40131.54 162086.53 15 NV 13353.74 40038.79 161978.12 15 OR 13285 39728 156728.51 15 WA 13407.5 40196 163646.78 14 AZ 13289.74 39947.16 162545.19 14 CA 13344.60 40131.52 162046.78 14 NV 13354.01 40040.34 161980.22 14 OR 13285 39728 156728.51 14 WA 13407.5 40196 163646.78 13 AZ 13289.61 39946.91 162545.31 13 CA 13340.12 40114.29 161976.95 13 NV 13354.44 40042.77 161983.47 13 OR 13285 39728 156728.51 13 WA 13407.5 40196 163646.78 12 AZ 13290.69 39948.97 162544.38 12 CA 13344.55 40129.09 162038.81 12 NV 13354.74 40044.47 161985.75 12 OR 13285 39728 156728.51 12 WA 13407.5 40196 163646.78 11 AZ 13289.87 39947.41 162545.08 11 CA 13339.47 40111.94 161962.78 11 NV 13354.22 40041.54 161981.81 11 OR 13285 39728 156728.51 11 WA 13407.5 40196 163646.78 10 AZ 13289.48 39946.67 162545.44 10 CA 13339.31 40112.58 161972.17 10 NV 13355.37 40048.06 161990.56 10 OR 13285 39728 156728.51 10 WA 13407.5 40196 163646.78 09 AZ 13292 39951.44 162543.22 09 CA 13341.44 40119.32 162012.52 09 NV 13355.28 40047.6 161989.94 09 OR 13285 39728 156728.51 09 WA 13407.5 40196 163646.78 08 AZ 13289.35 39946.42 162545.55 08 CA 13343.60 40125.98 162040.47 08 NV 13354.97 40045.79 161987.52 08 OR 13285 39728 156728.51 08 WA 13407.5 40196 163646.78 07 AZ 13290.41 39948.44 162544.62 07 CA 13342.79 40120.89 162007.67 07 NV 13354.29 40041.95 161982.36 07 OR 13285 39728 156728.51 07 WA 13407.5 40196 163646.78 06 AZ 13289.74 39947.16 162545.19 06 CA 13348.13 40139.10 162071.47 06 NV 13354.08 40040.74 161980.72 06 OR 13285 39728 156728.51 06 WA 13407.5 40196 163646.78 05 AZ 13289.74 39947.16 162545.19 05 CA 13344.35 40128.22 162028.19 05 NV 13354.52 40043.2 161984.02 05 OR 13285 39728 156728.51 05 WA 13407.5 40196 163646.78 04 AZ 13289.74 39947.16 162545.19 04 CA 13337.48 40106.49 161967.88 04 NV 13354.37 40042.36 161982.9 04 OR 13285 39728 156728.51 04 WA 13407.5 40196 163646.78 03 AZ 13289.70 39948.31 162554.69 03 CA 13345.06 40131.09 162048.64 03 NV 13353.74 40038.79 161978.12 03 OR 13285 39728 156728.51 03 WA 13407.5 40196 163646.78 02 AZ 13290.00 39947.66 162544.98 02 CA 13346.88 40138.05 162069.19 02 NV 13354.44 40042.77 161983.47 02 OR 13285 39728 156728.51 02 WA 13407.5 40196 163646.78 01 AZ 13290.69 39948.97 162544.38 01 CA 13341.47 40120.85 162005.16 01 NV 13354.44 40042.77 161983.47 01 OR 13285 39728 156728.51 01 WA 13407.5 40196 163646.78 java TimeRollUp week zip 1 0 a Week , zip , Number of Sales , Total number of sold items , Total $$ made 0 94171 132 376 1527.58 30 94171 173 536 2119.09 35 94171 182 533 2155.81 52 94171 185 578 2342.14 22 94171 187 535 2374.56 4 94171 187 526 2190.26 43 94171 202 613 2235.42 13 94171 203 587 2216.39 11 94171 204 660 2769.73 26 94171 214 669 2666.61 5 94171 229 686 2681.7 37 94171 229 637 2262.76 31 94171 230 686 2839.66 34 94171 232 681 2644.03 28 94171 234 673 2913.58 24 94171 234 739 3420.45 18 94171 234 707 2777.63 25 94171 238 704 3059.16 19 94171 239 737 3231.88 17 94171 241 742 2909.42 39 94171 241 707 2791.68 45 94171 242 687 2833.23 48 94171 242 707 3420.22 44 94171 244 729 3096.72 27 94171 244 746 2867.38 21 94171 249 780 3043.38 3 94171 252 781 2903.26 16 94171 253 777 3142.94 12 94171 257 780 3461.06 38 94171 258 773 3189.67 47 94171 262 786 3161.72 29 94171 263 767 3038.46 7 94171 264 799 3152.31 6 94171 268 804 3047.67 14 94171 271 803 3086.45 1 94171 272 772 3156.63 15 94171 274 810 2881.92 2 94171 277 817 3147.43 50 94171 277 846 3678.21 36 94171 282 885 3768.39 9 94171 284 816 3842.3 23 94171 284 899 3579.49 49 94171 285 834 3350.09 10 94171 296 911 3846.83 41 94171 299 860 3409.34 51 94171 302 943 3519.61 20 94171 305 952 3800.56 40 94171 307 927 3695.85 32 94171 314 960 3445.97 46 94171 315 957 3899.79 42 94171 320 950 3883.47 8 94171 358 1048 3745.84 33 94171 358 1110 4247.78 0 98111 1235 3628 15128.17 0 93308 1264 3835 14901.45 0 94211 1312 3865 16204.07 0 85016 1318 3961 16065 0 85701 1320 3986 16067.93 0 93943 1327 3976 15981.93 0 93108 1359 4017 15803.29 0 98512 1360 4175 16712.05 0 93405 1372 4099 16249.95 0 95106 1373 4040 16845.5 0 92110 1376 4165 16994.26 0 89101 1382 4128 16493.83 0 89507 1397 4216 16834.91 0 97209 1411 4204 16476.65 0 86001 1421 4245 17361.85 0 90081 1431 4322 16105 0 95208 1554 4663 19348.21 4 93308 2207 6619 26620 4 92110 2218 6621 26381.81 4 86001 2221 6741 27814.77 4 98111 2253 6754 27549.91 4 90081 2256 6816 27591.95 4 93108 2284 6796 27436.72 4 95208 2287 6905 27945.27 4 94211 2295 6869 28608.27 4 85701 2320 7018 27151.62 4 93405 2336 6918 28380.18 4 85016 2342 7102 29391.49 4 89101 2351 7013 28360.19 4 95106 2359 7087 29287.88 4 89507 2363 7063 28481.19 4 98512 2414 7199 30039.71 4 97209 2485 7339 28972.27 4 93943 2493 7476 29956.22 0 90001 2731 8288 33170.55 1 90081 2991 9044 36059.63 1 97209 2994 9029 35866.54 3 98512 3046 9229 36821.22 1 93108 3056 9140 37083.69 2 93108 3074 9289 37891.07 1 89101 3094 9200 37418.29 2 95106 3094 9250 37282.72 3 94211 3097 9376 38096.79 3 86001 3119 9314 37748.37 2 93308 3120 9359 37469.45 1 93943 3124 9295 37717.02 2 93405 3125 9509 39429.07 3 85701 3126 9369 37994.15 3 90081 3157 9408 37448.74 1 94211 3160 9449 38319.83 2 85016 3161 9408 38535.02 3 92110 3162 9446 38139.61 1 85016 3162 9452 37531 1 95208 3175 9581 37533.74 3 93108 3180 9550 38830.05 1 86001 3186 9617 38652.25 3 85016 3189 9502 38821.71 2 97209 3195 9482 37352.69 1 95106 3196 9549 38660.5 3 89507 3197 9619 37742.47 3 97209 3200 9674 38060.36 2 92110 3212 9705 39251.66 2 95208 3221 9814 39013.13 1 89507 3221 9719 38589.95 2 98111 3222 9526 38848.37 2 93943 3233 9592 39482.21 2 89507 3234 9754 40775.62 2 94211 3241 9794 39230.13 3 89101 3247 9713 39505.07 2 89101 3264 9895 40080.18 2 90081 3267 9754 40138.93 3 98111 3281 9983 41137.88 1 92110 3292 10012 39365.39 1 93308 3296 9891 40936.08 3 93943 3305 9827 40023.1 2 98512 3307 9743 38696.55 3 95208 3307 9989 41278.77 2 86001 3311 9970 40995.83 1 98512 3315 9945 41208.01 1 93405 3322 10070 40977.78 1 85701 3337 10116 41271.65 3 93308 3357 9950 40191.98 3 95106 3358 9971 40856.74 1 98111 3382 10210 41151.7 3 93405 3383 10211 41689.37 2 85701 3394 10150 42182.23 4 90001 4527 13507 54509.57 1 90001 6258 18588 73902.19 3 90001 6329 18994 76628.09 2 90001 6551 19740 80103.07 java EmployeeSlice Manager June June Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made Manager 06 310 932 3649.13 Shift Manager 06 411 1262 5700.42 java EmployeeSlice Full January May Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made Barista 01 10072 30230 124898.68 Cashier 01 19522 58795 238225.52 Manager 01 197098 590550 2384923.07 Shift Manager 01 12998 39168 156163.13 Manager 02 356 1059 4031.96 Shift Manager 02 347 1046 4128.33 Manager 03 369 1168 4802.67 Shift Manager 03 343 989 4427.76 Manager 04 407 1214 4607.43 Shift Manager 04 386 1180 4617.47 Manager 05 362 1144 4511.57 Shift Manager 05 327 1009 4504.73 java EmployeeSlice Barista January December Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made Barista 01 18747 56362 231624.5 Barista 02 443 1321 4732.81 Barista 03 369 1109 5193.87 Barista 04 350 1039 3891.43 Barista 05 370 1121 4187.98 Barista 06 324 1012 4393.05 Barista 07 371 1093 4159.29 Barista 08 312 942 3523.06 Barista 09 348 1047 3734.14 Barista 10 375 1113 4281.65 Barista 11 422 1230 4823.29 Barista 12 427 1298 5454.83 java StoreRank 1 3 state Chocolate Cake Rank of location 1: 6 out of 12 java StoreRank 1 2 July Drink Rank of location 1: 1 out of 1 java StoreRank 5 1 January Rank of location 5: 16 out of 20