[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Williams, Sydney, J,15334 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Rodriguez, Lucas, P,15942 | 191.87 | 0.00 | 0.00 | 0.00 | 191.87 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 0.00 | 273.90 |
| Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
| Jai, Adam,25095 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Martinez, Hannah, M,24666 | 4370.61 | 0.00 | 3578.27 | 0.00 | 792.34 |
| Sanders, Angel,16219 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Wilson, Hunter, R,27230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Sharma, Yolanda, K,25048 | 3046.84 | 0.00 | 2443.35 | 603.49 | 0.00 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Ward, Angela, M,27756 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gutierrez, Jerome,12783 | 2420.46 | 0.00 | 0.00 | 0.00 | 2420.46 |
| Rivera, Ariana,26173 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Campbell, Kevin, S,12177 | 4811.50 | 0.00 | 0.00 | 2404.46 | 2407.04 |
| Jones, Alexander, I,20021 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Martin, Kellie, R,28195 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Sanders, Chloe, C,23137 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 105.05 | 741.72 |
| Richardson, Arianna, C,12055 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Malhotra, Gerald, A,28773 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gutierrez, Linda, D,28575 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Mr., Smith, Jeff,29283 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Diaz, Trevor, B,20519 | 54.96 | 0.00 | 0.00 | 0.00 | 54.96 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Zhao, Clarence, R,19826 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Phillips, Luis, G,20734 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Griffin, Melissa, L,28780 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Alexander, Aidan,17387 | 148.19 | 0.00 | 0.00 | 56.97 | 91.22 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 0.00 | 4813.04 |
| Hall, Wyatt,23827 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Stewart, Destiny,13144 | 281.47 | 0.00 | 0.00 | 134.98 | 146.49 |
| Morris, Richard,20070 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Taylor, Edward, C,17442 | 319.88 | 0.00 | 0.00 | 230.90 | 88.98 |
| Foster, Abigail,19823 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Wilson, Tyler, L,15879 | 196.93 | 0.00 | 0.00 | 0.00 | 196.93 |
| Shan, Chad, M,24621 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Martinez, Carol, D,17656 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Perry, Jonathan, T,27026 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 78.98 | 85.48 |
| Henderson, Gabrielle, B,18603 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Price, Jocelyn, D,25875 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Diaz, Gabrielle,14893 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Morris, Alyssa,28072 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 410.31 | 880.02 |
| Garcia, Cameron,18641 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Sharma, Samuel,27725 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Cox, Katelyn, B,21742 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Gonzales, Miranda,11660 | 324.72 | 0.00 | 0.00 | 0.00 | 324.72 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 34.99 | 599.85 |
| Harris, Samuel, M,24771 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
| Wedge, Andrew, T,12060 | 4811.54 | 0.00 | 0.00 | 2418.48 | 2393.06 |
| Rivera, Makayla, A,28783 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Thomas, Dalton,23009 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Harris, Noah,29256 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Clark, Lauren,17034 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Evans, Alexandra,24322 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Thomas, Victoria, A,15536 | 249.53 | 0.00 | 0.00 | 0.00 | 249.53 |
| Lewis, Seth,26782 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Bailey, Maria, C,19150 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Cox, Devin, C,13418 | 4768.05 | 0.00 | 0.00 | 0.00 | 4768.05 |
| Lewis, Jeremiah,14371 | 87.26 | 0.00 | 0.00 | 49.97 | 37.29 |
| Watson, Devin, A,18875 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Smith, Nathan,21764 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 2407.04 | 0.00 |
| Coleman, Benjamin, F,23486 | 5343.23 | 0.00 | 3578.27 | 0.00 | 1764.96 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Collins, Charles, B,29041 | 628.45 | 0.00 | 0.00 | 0.00 | 628.45 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 267.62 | 888.28 |
| Ramirez, Jennifer, E,21311 | 4472.58 | 0.00 | 0.00 | 2049.10 | 2423.48 |
| Henderson, Jordan, C,22996 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Sanchez, Richard, L,27406 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Bryant, Isabella, L,22995 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Smith, Zachary, W,23783 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 14.98 | 78.87 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Bailey, Marcus, L,18329 | 146.53 | 0.00 | 0.00 | 23.78 | 122.75 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 94.98 | 59.56 |
| Watson, Victoria,16125 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Powell, Ian,26085 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Thomas, Ian,19118 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Rodriguez, Joshua, A,23511 | 4843.11 | 0.00 | 3578.27 | 0.00 | 1264.84 |
| Price, Oscar, G,11833 | 240.01 | 0.00 | 0.00 | 0.00 | 240.01 |
| Martin, Brandon, S,21691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rivera, Rachel, S,28996 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ramirez, Abigail, S,15859 | 74.14 | 0.00 | 0.00 | 0.00 | 74.14 |
| Morris, Mason, J,22349 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Lee, Alexander, S,18356 | 149.91 | 0.00 | 0.00 | 0.00 | 149.91 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 |
| Patterson, Natalie,16123 | 629.97 | 0.00 | 0.00 | 0.00 | 629.97 |
| Long, Jordyn,17338 | 47.25 | 0.00 | 0.00 | 0.00 | 47.25 |
| Carter, Madeline, A,27522 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Foster, Emma,15468 | 436.35 | 0.00 | 0.00 | 159.99 | 276.36 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Serrano, Albert, E,13328 | 4708.02 | 0.00 | 0.00 | 0.00 | 4708.02 |
| McDonald, Aaron, J,27734 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Lal, Robert, L,14084 | 138.68 | 0.00 | 0.00 | 0.00 | 138.68 |
| Collins, Nathan, F,19704 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Ross, Kaitlyn,16121 | 614.47 | 0.00 | 0.00 | 0.00 | 614.47 |
| Powell, Vanessa,26630 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Bailey, Olivia,23892 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-11-02 05:21:00.663 UTC