java LocationRollUp city 3 0 city , Number of Sales , Total number of sold items , Total $$ made Los Angeles 455 1348 5351.78 San Diego 213 646 2689.86 Sacramento 200 594 2507.07 Flagstaff 206 617 2444.73 Reno 222 647 2426.97 Olympia 199 580 2418.86 Phoenix 190 597 2399.02 San Luis Obispo 203 594 2326.85 Santa Barbara 178 537 2229.38 San Jose 159 498 2166.47 Portland 164 499 2157.53 Tucson 165 518 2082.89 Las Vegas 172 495 2080.26 Bakersfield 183 545 2079.78 Stockton 165 501 2044.24 San Francisco 180 512 1969.63 Seattle 181 541 1930.79 Monterey 103 296 1162.85 java LocationRollUp zip 2 1 a zip , AVG Number of Sales , AVG number of sold items , AVG $$ made 93943 103 296 1162.85 90001 144.5 430.5 1763.50 90081 166 487 1824.77 89101 172 495 2080.26 95106 159 498 2166.47 97209 164 499 2157.53 95208 165 501 2044.24 94171 180 512 1969.63 85701 165 518 2082.89 93108 178 537 2229.38 98111 181 541 1930.79 93308 183 545 2079.78 98512 199 580 2418.86 94211 200 594 2507.07 93405 203 594 2326.85 85016 190 597 2399.02 86001 206 617 2444.73 92110 213 646 2689.86 89507 222 647 2426.97 java LocationRollUp location 1 0 d Store , Number of Sales , Total number of sold items , Total $$ made 16 222 647 2426.97 6 213 646 2689.86 19 206 617 2444.73 2 203 594 2326.85 11 200 594 2507.07 15 199 580 2418.86 18 190 597 2399.02 10 183 545 2079.78 14 181 541 1930.79 1 180 512 1969.63 8 178 537 2229.38 17 172 495 2080.26 3 166 487 1824.77 20 165 518 2082.89 12 165 501 2044.24 13 164 499 2157.53 7 159 498 2166.47 5 158 453 1905.52 4 131 408 1621.49 9 103 296 1162.85 java LocationRollUpSlice location item Chocolate Cake 2 0 d Store , Number of Sales , Total number of sold items , Total $$ made 16 222 647 2426.97 6 213 646 2689.86 19 206 617 2444.73 18 190 597 2399.02 11 200 594 2507.07 2 203 594 2326.85 15 199 580 2418.86 10 183 545 2079.78 14 181 541 1930.79 8 178 537 2229.38 20 165 518 2082.89 1 180 512 1969.63 12 165 501 2044.24 13 164 499 2157.53 7 159 498 2166.47 17 172 495 2080.26 3 166 487 1824.77 5 158 453 1905.52 4 131 408 1621.49 9 103 296 1162.85 java LocationRollUpSlice state type Drink 1 1 state , AVG Number of Sales , AVG number of sold items , AVG $$ made AZ 47.33 142.33 363.79 NV 43 125.5 310.59 WA 37 108.5 247.37 CA 34.33 105.91 259.23 OR 34 107 254.7 java LocationRollUpSlice zip Food Cookie 3 0 a zip , Number of Sales , Total number of sold items , Total $$ made 93943 103 296 1162.85 90081 166 487 1824.77 98111 181 541 1930.79 94171 180 512 1969.63 95208 165 501 2044.24 93308 183 545 2079.78 89101 172 495 2080.26 85701 165 518 2082.89 97209 164 499 2157.53 95106 159 498 2166.47 93108 178 537 2229.38 93405 203 594 2326.85 85016 190 597 2399.02 98512 199 580 2418.86 89507 222 647 2426.97 86001 206 617 2444.73 94211 200 594 2507.07 92110 213 646 2689.86 90001 289 861 3527.01 java TimeRollUp month location 0 0 d Month , location , Number of Sales , Total number of sold items , Total $$ made 12 1 14 38 121.05 11 1 18 57 250.69 10 1 15 51 241.79 09 1 9 27 49.83 08 1 24 77 240.85 07 1 15 46 116.31 06 1 23 62 238.21 05 1 18 42 148.55 04 1 8 21 88.23 03 1 10 22 113.22 02 1 6 18 134.44 01 1 20 51 226.46 01 2 203 594 2326.85 01 3 166 487 1824.77 01 4 131 408 1621.49 01 5 158 453 1905.52 01 6 213 646 2689.86 01 7 159 498 2166.47 01 8 178 537 2229.38 01 9 103 296 1162.85 01 10 183 545 2079.78 01 11 200 594 2507.07 01 12 165 501 2044.24 01 13 164 499 2157.53 01 14 181 541 1930.79 01 15 199 580 2418.86 01 16 222 647 2426.97 01 17 172 495 2080.26 01 18 190 597 2399.02 01 19 206 617 2444.73 01 20 165 518 2082.89 java TimeRollUp day state 0 1 d Day , state , AVG Number of Sales , AVG number of sold items , AVG $$ made 29 AZ 185.58 583.05 2343.23 29 CA 180.80 537.32 2151.85 29 NV 172 495 2080.26 29 OR 164 499 2157.53 29 WA 195.08 571.52 2312.75 28 AZ 180.83 568.03 2283.10 28 CA 176.64 528.70 2163.77 28 NV 206.61 600.23 2320.29 28 OR 164 499 2157.53 28 WA 197.5 576.75 2378.18 27 AZ 196.85 605.57 2418.61 27 CA 172.50 509.79 2024.88 27 NV 206.78 600.73 2321.44 27 OR 164 499 2157.53 27 WA 190 560.5 2174.82 26 AZ 191.21 584.32 2329.74 26 CA 177.90 533.46 2169.98 26 NV 188.66 545.66 2195.83 26 OR 164 499 2157.53 26 WA 188.36 556.95 2130.45 25 AZ 182.45 568.21 2278.27 25 CA 162.21 485.66 1963.33 25 NV 200.57 581.85 2278.38 25 OR 164 499 2157.53 25 WA 195.14 571.64 2314.27 24 AZ 182.06 566.18 2269.28 24 CA 180.39 532.16 2135.62 24 NV 203.25 590 2296.95 24 WA 181 541 1930.79 23 AZ 196.20 598.79 2386.16 23 CA 182.08 543.08 2219.10 23 NV 190.18 550.27 2206.33 23 OR 164 499 2157.53 23 WA 198.1 578.05 2394.45 22 AZ 193.64 595.94 2380.65 22 CA 171.95 508.15 2087.99 22 NV 172 495 2080.26 22 OR 164 499 2157.53 22 WA 186.68 553.31 2084.91 21 AZ 189.37 580.29 2315.65 21 CA 173.59 518.42 2134.04 21 NV 197 571 2253.61 21 WA 193.85 568.85 2279.41 20 AZ 193.33 590.55 2354.16 20 CA 168.89 502.25 2043.54 20 NV 190.18 550.27 2206.33 20 OR 164 499 2157.53 20 WA 185.15 550 2043.42 19 AZ 201.07 610.84 2430.66 19 CA 175.09 525.08 2142.10 19 NV 172 495 2080.26 19 OR 164 499 2157.53 19 WA 187 554 2093.48 18 AZ 182.15 565.15 2263.66 18 CA 177.91 523.42 2051.30 18 NV 212 616.6 2357.62 18 OR 164 499 2157.53 18 WA 181 541 1930.79 17 AZ 178.66 551 2203.50 17 CA 172.97 518.64 2091.74 17 NV 213.66 621.66 2369.18 17 WA 199 580 2418.86 16 AZ 194.79 593.04 2361.72 16 CA 177.5 533 2181.80 16 NV 206.61 600.23 2320.29 16 OR 164 499 2157.53 16 WA 187 554 2093.48 15 AZ 184.44 579.44 2328.76 15 CA 186.24 559.33 2268.34 15 NV 210.23 611.23 2345.39 15 OR 164 499 2157.53 15 WA 190.69 562 2193.59 14 AZ 178.66 551 2203.50 14 CA 173.06 517.64 2119.08 14 NV 192 555.8 2218.94 14 OR 164 499 2157.53 14 WA 193.85 568.85 2279.41 13 AZ 191.31 587 2343.09 13 CA 172.47 512.75 2079.69 13 NV 193.15 559.30 2226.94 13 OR 164 499 2157.53 13 WA 181 541 1930.79 12 AZ 188 579.42 2316.03 12 CA 186.23 554.67 2242.21 12 NV 187.38 541.76 2186.94 12 OR 164 499 2157.53 12 WA 185 549.66 2039.25 11 AZ 182.08 559.25 2233.65 11 CA 171.46 509.19 2029.96 11 NV 184.5 533 2166.93 11 OR 164 499 2157.53 11 WA 188.2 556.6 2126.01 10 AZ 165 518 2082.89 10 CA 170.28 506.32 2042.87 10 NV 172 495 2080.26 10 OR 164 499 2157.53 10 WA 190 560.5 2174.82 09 AZ 203 613.25 2436.15 09 CA 171.48 507.45 2049.66 09 NV 213.66 621.66 2369.18 09 OR 164 499 2157.53 09 WA 181 541 1930.79 08 AZ 206 617 2444.73 08 CA 171.91 507.40 2035.21 08 NV 210.88 613.22 2349.92 08 OR 164 499 2157.53 08 WA 187.54 555.18 2108.27 07 AZ 179.1 559.5 2245.52 07 CA 179.48 533.72 2163.51 07 NV 193.05 559 2226.24 07 OR 164 499 2157.53 07 WA 192.07 565 2231.14 06 AZ 190.11 587.96 2352.29 06 CA 174.01 518.32 2081.90 06 NV 172 495 2080.26 06 OR 164 499 2157.53 06 WA 188.57 557.42 2136.29 05 AZ 181.88 558.76 2231.88 05 CA 174.29 518.77 2110.86 05 NV 222 647 2426.97 05 OR 164 499 2157.53 05 WA 185.5 550.75 2052.80 04 AZ 183.52 570.71 2287.29 04 CA 177.61 532.52 2167.39 04 NV 213.66 621.66 2369.18 04 OR 164 499 2157.53 04 WA 199 580 2418.86 03 AZ 198.61 607.76 2423.63 03 CA 160.31 472.42 1920.31 03 NV 190.75 552 2210.27 03 OR 164 499 2157.53 03 WA 194.5 570.25 2296.84 02 AZ 206 617 2444.73 02 CA 176.52 520.38 2050.03 02 NV 200.57 581.85 2278.38 01 AZ 193.32 591.6 2359.56 01 CA 176.53 522.98 2107.24 01 NV 198.92 576.84 2266.95 01 WA 185 549.66 2039.25 java TimeRollUp week zip 1 0 a Week , zip , Number of Sales , Total number of sold items , Total $$ made 12 94171 2 6 7.5 8 94171 2 9 56.55 42 94171 2 7 67.25 21 94171 3 6 18.05 49 94171 3 10 18.7 23 94171 3 9 21.75 0 94171 3 6 26.2 0 97209 3 9 17.05 20 94171 3 7 14.05 22 94171 3 5 15.65 17 94171 3 6 42.8 48 94171 3 11 44.25 32 94171 3 9 24.15 10 94171 4 7 34.55 5 94171 4 9 77.89 35 94171 4 10 18 29 94171 4 15 28.91 11 94171 4 9 71.17 46 94171 4 12 24.54 0 85701 5 21 79.85 1 94171 5 14 23.4 47 94171 5 14 52.54 15 94171 5 15 45.43 19 94171 5 8 11.9 33 94171 6 20 111 2 94171 6 18 105.61 4 94171 6 13 71.25 36 94171 6 18 36.88 18 94171 7 21 104.55 4 93943 7 22 98 43 94171 7 22 57.18 24 94171 7 20 97.7 51 94171 8 17 58.1 39 94171 9 31 130.31 0 92110 9 31 137.8 0 93405 9 21 115.62 45 94171 9 31 173.61 25 94171 10 28 103.11 31 94171 11 38 87.7 0 90081 11 28 59.62 30 94171 11 31 87.4 0 95208 13 42 167.56 0 98512 14 41 184.19 0 85016 14 49 170.77 4 94211 16 52 251.42 0 93108 17 46 182.24 0 93943 17 39 183.68 0 98111 17 46 121.14 4 93108 18 48 138.9 0 93308 20 59 209.95 0 90001 20 63 270.91 0 86001 21 66 236.99 2 93943 22 65 225.19 4 95208 23 69 259.1 0 94211 23 70 397.82 4 98111 25 78 296.47 0 89101 26 89 313.91 1 93943 27 78 306.78 3 93308 27 75 254.43 1 89101 29 85 258.79 4 89101 30 70 362.44 3 85701 30 98 374.47 3 93943 30 92 349.2 4 86001 30 79 320.03 4 93405 31 81 344.28 3 89507 33 90 417.8 1 85016 33 108 370.02 1 95106 34 99 359.85 1 90081 34 101 428.78 0 89507 34 111 436.2 2 93108 34 95 293.29 2 98111 35 95 422 3 95106 36 112 590.59 3 97209 36 112 516.02 4 93308 36 113 451.83 1 85701 37 124 497.11 2 90081 37 119 440.01 3 85016 37 112 445.28 2 98512 37 111 409.51 4 89507 38 115 382.86 4 92110 38 111 533.6 2 85016 39 125 550.13 3 95208 39 131 467.53 4 97209 39 119 631.66 1 94211 40 109 504.35 3 89101 40 112 536.71 1 86001 41 120 442.19 4 90081 41 106 480.18 4 85701 41 128 604.37 1 98512 42 134 552.5 2 95106 42 138 624.77 3 90081 43 133 416.18 1 97209 43 130 507.34 2 97209 43 129 485.46 3 98111 44 138 388.32 2 95208 44 130 573.49 1 93308 44 133 431.18 3 92110 45 137 659.04 1 95208 46 129 576.56 3 93405 46 146 510.36 3 98512 47 132 629.98 3 93108 47 158 715 2 89101 47 139 608.41 4 95106 47 149 591.26 1 92110 48 151 520.53 3 90001 49 144 589.8 1 93405 50 140 613.08 2 85701 52 147 527.09 2 94211 56 173 655.06 2 93308 56 165 732.39 3 86001 56 177 689.51 2 89507 58 157 506.39 2 86001 58 175 756.01 1 89507 59 174 683.72 4 98512 59 162 642.68 1 98111 60 184 702.86 1 93108 62 190 899.95 4 90001 64 189 643.48 3 94211 65 190 698.42 4 85016 67 203 862.82 2 93405 67 206 743.51 2 92110 73 216 838.89 1 90001 74 220 1093.13 2 90001 82 245 929.69 java EmployeeSlice Manager June June Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made Manager 06 23 62 238.21 java EmployeeSlice Full January May Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made Barista 01 84 231 886.42 Cashier 01 248 729 3205.24 Manager 01 2538 7653 30925.16 Shift Manager 01 314 933 3636.67 Manager 02 6 18 134.44 Manager 03 10 22 113.22 Manager 04 8 21 88.23 Manager 05 18 42 148.55 java EmployeeSlice Barista January December Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made Barista 01 216 622 2412.48 java StoreRank 1 3 state Chocolate Cake Rank of location 1: 8 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: 17 out of 20