[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 SKIP 0 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Phillips, Aaron, R,24947 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 0.00 | 232.71 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Howard, Alexandra,20736 | 3194.58 | 0.00 | 0.00 | 2049.10 | 1145.48 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Russell, Rachel, C,21581 | 24.27 | 0.00 | 0.00 | 24.27 | 0.00 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
| Gray, Isabella,16820 | 3217.79 | 0.00 | 0.00 | 0.00 | 3217.79 |
| Foster, Deb,21501 | 2661.40 | 0.00 | 0.00 | 2661.40 | 0.00 |
| Washington, Hailey, S,25885 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Lopez, Jack, I,29047 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 14.98 | 78.87 |
| Cook, Seth,23010 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Price, Miranda,26629 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Cooper, Ariana,17348 | 205.42 | 0.00 | 0.00 | 0.00 | 205.42 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Posti, Juha-Pekka,22219 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Richardson, Nathaniel,12089 | 4710.03 | 0.00 | 0.00 | 2316.97 | 2393.06 |
| Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Brooks, Evan,23401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Barry, M,27282 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Cassidy, A,17586 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Gray, Seth, M,20087 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Perry, Jackson, J,21306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chen, Jonathan, G,13096 | 200.69 | 0.00 | 0.00 | 0.00 | 200.69 |
| Li, Rafael, M,21752 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 0.00 | 164.46 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Ward, Emma, W,21796 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Carter, Elijah,21618 | 2611.07 | 0.00 | 0.00 | 2611.07 | 0.00 |
| Howard, Natalie,13491 | 54.96 | 0.00 | 0.00 | 14.98 | 39.98 |
| Adams, Katherine, M,23518 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Carly,19839 | 194.96 | 0.00 | 0.00 | 0.00 | 194.96 |
| Sanders, Alexa, E,21741 | 4127.25 | 3578.27 | 0.00 | 0.00 | 548.98 |
| Jones, Charles,22882 | 101.45 | 0.00 | 0.00 | 0.00 | 101.45 |
| Perry, Samuel,18811 | 100.96 | 0.00 | 0.00 | 0.00 | 100.96 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 0.00 | 109.95 |
| Rivera, Allison, M,13751 | 224.91 | 0.00 | 0.00 | 0.00 | 224.91 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Alexander, Taylor,17482 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 130.94 | 793.67 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| Lee, Don,18839 | 2384.97 | 0.00 | 0.00 | 0.00 | 2384.97 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Henderson, Isabelle, K,16366 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Hall, Natalie, A,23070 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Gonzales, Luis,15856 | 116.25 | 0.00 | 0.00 | 37.27 | 78.98 |
| Allen, Allison, A,19757 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Blue, Marcus, L,27550 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Martinez, Kristina, S,21345 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Alexander, Jordan,21412 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Lewis, Seth,26782 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| Adams, Mason, T,20528 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanders, Alexandra,25911 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Cannata, Gabrielle, C,21725 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gutierrez, Linda, D,28575 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Shan, Benjamin,23566 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Brooks, Jacqueline, W,28254 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ramirez, Makayla, L,17509 | 98.72 | 0.00 | 0.00 | 0.00 | 98.72 |
| Gonzalez, James, M,18842 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Lee, Emma,16948 | 176.43 | 0.00 | 0.00 | 0.00 | 176.43 |
| Sanchez, Jared, J,25850 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| White, Cameron,23830 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Hall, Morgan,21726 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 96.07 | 913.17 |
| Mitchell, Bailey, B,26706 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 0.00 | 155.91 |
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| James, Zoe, R,14611 | 304.55 | 0.00 | 0.00 | 0.00 | 304.55 |
| Bryant, Isabelle,23397 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Ward, Juan, H,21595 | 2649.56 | 0.00 | 0.00 | 2049.10 | 600.46 |
| Reed, Erin, I,14353 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| Patterson, Aaron, W,19113 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Johnson, Anthony, D,27022 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ortega, Byron,23306 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Hall, Luke, E,14745 | 902.46 | 0.00 | 0.00 | 0.00 | 902.46 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Edwards, Eric,24627 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Bradley, Melanie, G,13343 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 |
| Edwards, Mackenzie, K,23458 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Sanchez, Stephanie,17867 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Rogers, Olivia,12020 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Robinson, Emily,12183 | 228.42 | 0.00 | 0.00 | 0.00 | 228.42 |
| Flores, Miguel,19750 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Ross, Kaitlyn,16121 | 614.47 | 0.00 | 0.00 | 0.00 | 614.47 |
| Bell, Christina,26099 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 0.00 | 2371.94 |
| Watson, Emma,17481 | 126.94 | 0.00 | 0.00 | 0.00 | 126.94 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Hall, Eduardo,16847 | 189.94 | 0.00 | 0.00 | 0.00 | 189.94 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Evans, Gabriel,23487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
| Cox, Sara, P,27758 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Johnson, James,23498 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Butler, Isabel,16241 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Clark, William,29021 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| She, Martha, E,22251 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
Generated 2025-12-21 22:37:57.950 UTC