[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 62 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nelson, Kevin,14765 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 0.00 | 1155.52 |
| Jenkins, Melissa, R,15997 | 4746.34 | 0.00 | 0.00 | 0.00 | 4746.34 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 0.00 | 123.94 |
| Bennett, Brittany, J,22332 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| Jackson, Elizabeth, K,16837 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 0.00 | 702.99 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
| Posti, Juha-Pekka,22219 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Rivera, Sara,18785 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| _SUM | 1806517.50 | 25543.71 | 493581.21 | 255540.50 | 1031852.08 |
| Carter, Jason,11724 | 210.09 | 0.00 | 0.00 | 71.58 | 138.51 |
| Hall, Natalie, A,23070 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Hall, Jose, J,17601 | 225.42 | 0.00 | 0.00 | 0.00 | 225.42 |
| Sanchez, Caitlin, M,22080 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Jenkins, Megan, R,12074 | 261.38 | 0.00 | 0.00 | 0.00 | 261.38 |
| Coleman, Logan,18686 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 0.00 | 2371.94 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| White, Emma, N,16090 | 604.96 | 0.00 | 0.00 | 0.00 | 604.96 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 0.00 | 275.50 |
| Lopez, Eduardo, J,26640 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Torres, Mackenzie,28153 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Bryant, Dakota, L,17613 | 2401.95 | 0.00 | 0.00 | 0.00 | 2401.95 |
| Moreno, Marie,27739 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
| Sanders, Megan, A,15376 | 136.24 | 0.00 | 0.00 | 0.00 | 136.24 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Foster, Olivia,23806 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Martin, Tyler, L,27724 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liu, Arturo,13222 | 150.41 | 0.00 | 0.00 | 0.00 | 150.41 |
| Sandberg, Nicole, M,12077 | 144.69 | 0.00 | 0.00 | 89.47 | 55.22 |
| Morris, Alyssa,28072 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Mr., Smith, Jeff,29283 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Morris, Mason, J,22349 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Morgan, Juan, C,18821 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Washington, Robert, J,14906 | 143.95 | 0.00 | 0.00 | 0.00 | 143.95 |
| Foster, Antonio,12795 | 108.54 | 0.00 | 0.00 | 28.99 | 79.55 |
| Russell, Megan,16220 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Turner, Andrea, A,20209 | 3268.55 | 0.00 | 2049.10 | 0.00 | 1219.45 |
| Smith, Katherine, J,13197 | 105.19 | 0.00 | 0.00 | 0.00 | 105.19 |
| Wright, Katelyn, A,14502 | 122.26 | 0.00 | 0.00 | 0.00 | 122.26 |
| Sandberg, Chase,21904 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Martin, Joshua, A,27607 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Wright, Jackson,11698 | 225.95 | 0.00 | 0.00 | 0.00 | 225.95 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Martin, Madison, C,20492 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Long, Sydney,27921 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Coleman, Dylan,27403 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Evans, Alexandra,24322 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Luo, Jodi,29213 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Thomas, Edward, E,19147 | 133.71 | 0.00 | 0.00 | 0.00 | 133.71 |
| Walker, Thomas,13071 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 0.00 | 1010.56 |
| Blanco, Randall,26321 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| Reed, Paige,22112 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Rodriguez, Anthony, G,23829 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Murphy, Caitlin, L,14910 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Jones, Charles,22882 | 101.45 | 0.00 | 0.00 | 0.00 | 101.45 |
| Howard, Erin, L,18362 | 1725.21 | 0.00 | 0.00 | 0.00 | 1725.21 |
| Martin, Brandon, S,21691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 0.00 | 87.25 |
| Brooks, Jennifer, L,17411 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Moore, Logan,26348 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Bradley, Evan,18506 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
| Diaz, Kaitlyn, B,29230 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 0.00 | 164.46 |
| Hughes, Brittany,14387 | 898.46 | 0.00 | 0.00 | 0.00 | 898.46 |
| Stewart, Olivia, B,18749 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Griffin, Jennifer, B,14244 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Flores, Caleb, S,12165 | 280.64 | 0.00 | 0.00 | 159.47 | 121.17 |
| Rodriguez, Alexis, L,15244 | 179.19 | 0.00 | 0.00 | 0.00 | 179.19 |
| Wilson, Emily,17400 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Bell, Danielle,14041 | 4765.02 | 0.00 | 0.00 | 0.00 | 4765.02 |
| Edwards, Hunter,24220 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 36.27 | 179.18 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Watson, Erin, B,22772 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carter, Savannah, M,12090 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Ward, Emma, W,21796 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| She, Martha, E,22251 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Brooks, Lucas, S,16089 | 342.03 | 0.00 | 0.00 | 0.00 | 342.03 |
| Rodriguez, Michael, E,16810 | 3064.63 | 0.00 | 0.00 | 0.00 | 3064.63 |
| Srini, Evelyn,16855 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Cook, Megan, J,20299 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Ramirez, Brian, M,11618 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 0.00 | 610.19 |
| Rivera, Ariana,26173 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Adams, Kyle, E,18812 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Andersen, Latoya, J,29057 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Lewis, Christopher,18755 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Powell, Spencer,14904 | 468.12 | 0.00 | 0.00 | 0.00 | 468.12 |
| Turner, Samuel,27420 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 0.00 | 273.90 |
| Campbell, Wyatt, C,27602 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thomas, Emily,21803 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Kaitlyn,23396 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 0.00 | 109.95 |
| Alexander, Logan, E,19116 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Flores, Jordyn,25288 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Rodriguez, Joshua, A,23511 | 4843.11 | 0.00 | 3578.27 | 0.00 | 1264.84 |
| Jones, Samantha,18317 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Sanders, Alexandra,25911 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Cox, Katelyn, B,21742 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Martinez, Wyatt, R,22881 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Coleman, Luke, A,11723 | 152.55 | 0.00 | 0.00 | 39.99 | 112.56 |
| Hayes, Carson, A,12447 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Rubio, Javier, E,19726 | 64.24 | 0.00 | 0.00 | 0.00 | 64.24 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Bennett, Isabelle, C,18674 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Johnson, Edward, H,23279 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Serrano, Albert, E,13328 | 4708.02 | 0.00 | 0.00 | 0.00 | 4708.02 |
| Mitchell, Lucas, C,19829 | 4533.45 | 0.00 | 3374.99 | 0.00 | 1158.46 |
| Thomas, Samantha,21690 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
Generated 2025-12-22 02:25:00.701 UTC