[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 30 < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Morris, Mackenzie, N,26474 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Sharma, Kathryn,20740 | 140.94 | 0.00 | 0.00 | 0.00 | 140.94 |
| Alexander, Lauren,18950 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| White, Cameron,23830 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Flores, Julia, E,17263 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Foster, Isabelle,26377 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Garcia, Benjamin, L,17595 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Peterson, Morgan, J,16834 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Clark, Anthony,27071 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Gonzales, Brittany,21710 | 4187.23 | 3578.27 | 0.00 | 0.00 | 608.96 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 0.00 | 2049.10 | 2359.46 |
| Parker, Natalie, A,25104 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Cooper, Brian, L,13760 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Garcia, Kayla, L,21308 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Foster, Isabel, M,21745 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Shan, Christian, L,23084 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Faith, M,22363 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Gonzales, Jordan,23681 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Gray, Isabella,16820 | 3217.79 | 0.00 | 0.00 | 0.00 | 3217.79 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 0.00 | 223.93 |
| Foster, Edward, R,18355 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 0.00 | 603.53 |
| Brown, Julia,18065 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Griffin, Miguel,21464 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Srini, Evelyn,16855 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Young, Julia, J,27414 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Green, Kaylee, C,26185 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Morris, Mason, J,22349 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Harrison, Trevor, A,18055 | 143.91 | 0.00 | 0.00 | 0.00 | 143.91 |
| Gonzales, Emily, P,21777 | 180.98 | 0.00 | 0.00 | 0.00 | 180.98 |
| Sanchez, Lucas, L,23351 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Jenkins, Austin, D,15748 | 296.91 | 0.00 | 0.00 | 0.00 | 296.91 |
| Robinson, Alyssa, C,23134 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hernandez, Jonathan, J,19014 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
| Rodriguez, Lucas, P,15942 | 191.87 | 0.00 | 0.00 | 0.00 | 191.87 |
| Nelson, Jose,19217 | 185.02 | 0.00 | 0.00 | 0.00 | 185.02 |
| Henderson, Hailey, C,17148 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Parker, Caleb, A,26318 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 0.00 | 273.18 |
| Henderson, Justin, P,23591 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Smith, Lucas, P,18090 | 64.91 | 0.00 | 0.00 | 0.00 | 64.91 |
| Sanders, Megan, A,15376 | 136.24 | 0.00 | 0.00 | 0.00 | 136.24 |
| Hayes, Austin,20208 | 3219.58 | 0.00 | 2049.10 | 0.00 | 1170.48 |
| Morris, Haley, A,23548 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Edwards, Madeline,20771 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Sanchez, Mariah, R,19220 | 66.65 | 0.00 | 0.00 | 0.00 | 66.65 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 0.00 | 200.94 |
| Sanders, Xavier,16721 | 73.75 | 0.00 | 0.00 | 0.00 | 73.75 |
| Powell, Blake, J,22371 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| Martinez, Hannah, M,24666 | 4370.61 | 0.00 | 3578.27 | 0.00 | 792.34 |
| Moreno, Meredith, D,22285 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 0.00 | 243.01 |
| Prasad, Molly,24392 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Murphy, Eduardo, S,16124 | 614.45 | 0.00 | 0.00 | 0.00 | 614.45 |
| Lopez, Eduardo, J,26640 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Li, Jordan,17026 | 261.39 | 0.00 | 0.00 | 0.00 | 261.39 |
| Zhang, Connor, R,13853 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| White, Greg, C,17403 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Price, Nicole, N,15815 | 141.83 | 0.00 | 0.00 | 0.00 | 141.83 |
| Roberts, Hunter,28260 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Powell, David, W,26615 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Martin, Gina, E,11078 | 793.27 | 0.00 | 0.00 | 0.00 | 793.27 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Martin, Noah, A,17657 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Powell, Jordyn, K,15391 | 4828.01 | 0.00 | 0.00 | 0.00 | 4828.01 |
| Cox, Lucas, J,25393 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Nath, Alison, J,17116 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Adams, Connor,21423 | 2888.56 | 0.00 | 0.00 | 2049.10 | 839.46 |
| Rivera, Allison, M,13751 | 224.91 | 0.00 | 0.00 | 0.00 | 224.91 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Shan, Chad, M,24621 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Foster, Antonio,12795 | 108.54 | 0.00 | 0.00 | 28.99 | 79.55 |
| Smith, John,19855 | 5709.96 | 0.00 | 3399.99 | 0.00 | 2309.97 |
| Cooper, Brianna,25925 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Flores, Megan, N,23074 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Reed, Kaitlyn, H,27413 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Anderson, Isabella,13743 | 2349.98 | 0.00 | 0.00 | 0.00 | 2349.98 |
| Martin, Brianna, M,23583 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Coleman, Logan,18686 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Gill, Beth,19997 | 5814.98 | 0.00 | 3374.99 | 0.00 | 2439.99 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Long, Kaitlyn,23396 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Madan, Carmen, V,15567 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 |
| Price, Isabelle,20182 | 5749.97 | 0.00 | 3374.99 | 0.00 | 2374.98 |
| Diaz, Brandon,23676 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Griffin, Jennifer, B,14244 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Richardson, Arianna, C,12055 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Jenkins, Dakota, D,20679 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Miller, Benjamin, G,26643 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Brown, Jonathan,11875 | 265.42 | 0.00 | 0.00 | 0.00 | 265.42 |
| Thomas, Charles,25094 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Bailey, Morgan, E,21354 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Smith, Hannah, J,25265 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Murphy, Chase, J,24729 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 21.98 | 86.56 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Stewart, Katherine, Z,22901 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Parker, Madeline, H,22182 | 6006.32 | 0.00 | 3578.27 | 0.00 | 2428.05 |
| Thompson, Jose,23731 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Stewart, Melissa,25173 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 36.27 | 179.18 |
| Sanchez, Adrian, L,13179 | 190.17 | 0.00 | 0.00 | 0.00 | 190.17 |
| Russell, Nicole, M,18237 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Bennett, Jordyn, L,22230 | 4223.23 | 0.00 | 3578.27 | 0.00 | 644.96 |
| Alexander, Jason,29328 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Simmons, Nicole, S,26177 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Wilson, Madison, H,19828 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Thomas, Richard,27557 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 0.00 | 3056.32 |
Generated 2025-12-22 02:10:09.716 UTC