[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 76 > < TAKE 112 >
112 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
| Gonzalez, Jeremiah,17468 | 128.91 | 0.00 | 0.00 | 0.00 | 128.91 |
| Price, Mariah, C,20745 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 0.00 | 1228.83 |
| Zhao, Clarence, R,19826 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Gonzalez, Logan, J,17483 | 64.50 | 0.00 | 0.00 | 0.00 | 64.50 |
| Evans, Kaylee,19642 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 21.98 | 86.56 |
| Edwards, Hunter,24220 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| Green, Sophia, E,24977 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Bell, Danielle,14041 | 4765.02 | 0.00 | 0.00 | 0.00 | 4765.02 |
| Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
| Robinson, Alyssa, C,23134 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hayes, Gavin, A,19400 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Serrano, Albert, E,13328 | 4708.02 | 0.00 | 0.00 | 0.00 | 4708.02 |
| Green, Blake, P,11719 | 287.20 | 0.00 | 0.00 | 0.00 | 287.20 |
| Adams, Katherine, M,23518 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Long, Caleb, P,25046 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Yuan, Leonard, F,16791 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Jones, Madison,24661 | 4181.76 | 0.00 | 3578.27 | 603.49 | 0.00 |
| Bennett, Antonio, C,11631 | 707.50 | 0.00 | 0.00 | 20.93 | 686.57 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
| Lopez, Jack, I,29047 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Powell, Ian,26085 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Cook, Jacqueline, A,19223 | 60.37 | 0.00 | 0.00 | 0.00 | 60.37 |
| Washington, Ian, M,24664 | 4368.58 | 0.00 | 3578.27 | 0.00 | 790.31 |
| Murphy, Emma,19844 | 5807.93 | 0.00 | 3374.99 | 0.00 | 2432.94 |
| Garcia, Hunter, J,21305 | 3204.58 | 0.00 | 0.00 | 2049.10 | 1155.48 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Martin, Thomas, A,16952 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Flores, Julia, E,17263 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Price, Miranda,26629 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Hill, Carlos,12919 | 257.88 | 0.00 | 0.00 | 0.00 | 257.88 |
| Powell, Jonathan,23858 | 4712.74 | 0.00 | 3578.27 | 0.00 | 1134.47 |
| White, Judith, R,14885 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lewis, Zachary, L,14760 | 167.26 | 0.00 | 0.00 | 0.00 | 167.26 |
| Ramirez, Jennifer, E,21311 | 4472.58 | 0.00 | 0.00 | 2049.10 | 2423.48 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Turner, Sean,22732 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Parker, Morgan, S,16772 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Gray, Mackenzie, L,17680 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Stewart, Melissa,25173 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 0.00 | 4793.02 |
| Hughes, Isabella,23048 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Martin, Nicholas,23362 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Griffin, Xavier,22877 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 73.87 | 1316.68 |
| Diaz, Luis, D,11203 | 801.77 | 0.00 | 0.00 | 0.00 | 801.77 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 34.99 | 616.99 |
| Rivera, Kaitlyn, R,15490 | 4813.52 | 0.00 | 0.00 | 0.00 | 4813.52 |
| James, Adrian, C,25340 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Roberts, Seth, H,11510 | 258.15 | 0.00 | 0.00 | 0.00 | 258.15 |
| Evans, Luke,29176 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Rogers, Paige, H,17125 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| White, Greg, C,17403 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Howard, Alexandra,20736 | 3194.58 | 0.00 | 0.00 | 2049.10 | 1145.48 |
| Butler, Victoria,13284 | 4767.53 | 0.00 | 0.00 | 0.00 | 4767.53 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Johnson, Cameron, R,13720 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Winston, Ethan, R,21622 | 2612.06 | 0.00 | 0.00 | 2049.10 | 562.96 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Martinez, Andrew, C,11530 | 523.81 | 0.00 | 0.00 | 78.48 | 445.33 |
| Foster, Aaron,15566 | 4912.47 | 0.00 | 0.00 | 0.00 | 4912.47 |
| Prasad, Summer, M,22143 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ashe, Alexis, S,19414 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Butler, Dalton, A,13345 | 4759.51 | 0.00 | 0.00 | 0.00 | 4759.51 |
| Flores, Gabriel,27111 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Perry, Brandon,22095 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Kennedy, Bridget,22026 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Gutierrez, Linda, D,28575 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 0.00 | 409.12 |
| Harris, Seth, M,16140 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 12.94 | 201.41 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Coleman, Luke, A,11723 | 152.55 | 0.00 | 0.00 | 39.99 | 112.56 |
| Turner, Morgan,11823 | 178.47 | 0.00 | 0.00 | 0.00 | 178.47 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 0.00 | 273.18 |
| Cook, Steven, J,27053 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Patterson, Taylor,12147 | 271.45 | 0.00 | 0.00 | 0.00 | 271.45 |
| Patterson, Eric, A,27384 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Morgan, Brianna, D,11136 | 2380.47 | 0.00 | 0.00 | 2380.47 | 0.00 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 0.00 | 198.73 |
| Prasad, Erick, E,28786 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Thomas, Samantha,21690 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Patterson, Nicole,19729 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Howard, Alyssa, A,11513 | 863.95 | 0.00 | 0.00 | 0.00 | 863.95 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Fernandez, Darren,28992 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Brown, Christian,22755 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Green, Eric,27380 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Washington, Ryan,28332 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Bryant, Connor,23842 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Patterson, Natalie,16123 | 629.97 | 0.00 | 0.00 | 0.00 | 629.97 |
| Luo, Jodi,29213 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
Generated 2025-12-21 23:15:04.393 UTC