[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 22 < SKIP 376 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Brooks, Paige,22232 | 5985.31 | 0.00 | 3578.27 | 0.00 | 2407.04 |
| Cooper, Timothy, J,20651 | 3198.57 | 0.00 | 0.00 | 2049.10 | 1149.47 |
| James, Juan,23267 | 4862.09 | 0.00 | 3578.27 | 0.00 | 1283.82 |
| Gray, Mariah,22278 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Long, Brandon, M,16110 | 650.47 | 0.00 | 0.00 | 0.00 | 650.47 |
| Kumar, Elijah,15197 | 156.92 | 0.00 | 0.00 | 0.00 | 156.92 |
| Miller, Chloe, V,22893 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| White, Cameron,23830 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Kennedy, Bridget,22026 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Moore, Wyatt, F,18971 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Price, Nicole, N,15815 | 141.83 | 0.00 | 0.00 | 0.00 | 141.83 |
| Diaz, Trevor, B,20519 | 54.96 | 0.00 | 0.00 | 0.00 | 54.96 |
| Ward, Eduardo, I,13916 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
| Johnson, Christopher,11979 | 4813.76 | 0.00 | 0.00 | 0.00 | 4813.76 |
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Williams, Destiny, S,15881 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Alexander, Edward, E,18524 | 195.95 | 0.00 | 0.00 | 0.00 | 195.95 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Murphy, Catherine, L,16506 | 92.05 | 0.00 | 0.00 | 0.00 | 92.05 |
| Peterson, Brian,12892 | 419.47 | 0.00 | 0.00 | 0.00 | 419.47 |
| Carter, Jason,11724 | 210.09 | 0.00 | 0.00 | 0.00 | 210.09 |
| Murphy, Brianna, K,28342 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Alvarez, Melody,25070 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Walker, Richard, T,19640 | 224.55 | 0.00 | 0.00 | 0.00 | 224.55 |
| Jones, Alexander, I,20021 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Robinson, Emily,12183 | 228.42 | 0.00 | 0.00 | 0.00 | 228.42 |
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 0.00 | 336.65 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Foster, Deb,21501 | 2661.40 | 0.00 | 0.00 | 2661.40 | 0.00 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Hughes, Anna,19705 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Smith, Zachary, W,23783 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Cook, Jacqueline, A,19223 | 60.37 | 0.00 | 0.00 | 0.00 | 60.37 |
| Martin, Jill, C,11824 | 181.03 | 0.00 | 0.00 | 0.00 | 181.03 |
| Russell, Xavier,12964 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Brown, Christian,22755 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 0.00 | 212.01 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Foster, Isabelle,26377 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Howard, Alexandra,20736 | 3194.58 | 0.00 | 0.00 | 2049.10 | 1145.48 |
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Brooks, Steven, C,14877 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Smith, Tyler, J,20341 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 0.00 | 170.91 |
| Alexander, Elijah,11738 | 331.68 | 0.00 | 0.00 | 49.48 | 282.20 |
| Henderson, Hailey, C,17148 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Hayes, Austin,20208 | 3219.58 | 0.00 | 2049.10 | 0.00 | 1170.48 |
| Raje, Mindy, A,16083 | 561.97 | 0.00 | 0.00 | 0.00 | 561.97 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Barnes, Kayla,24256 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 0.00 | 87.25 |
| Kelly, Julia,23798 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Thomas, Thomas,21629 | 2624.08 | 0.00 | 0.00 | 2049.10 | 574.98 |
| Jackson, Brianna,15377 | 97.91 | 0.00 | 0.00 | 0.00 | 97.91 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 0.00 | 66.53 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Martinez, Kristina, S,21345 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Howard, Isaiah,25981 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 0.00 | 409.12 |
| Brooks, Mariah,21620 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Peterson, Christina,28976 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Ma, Tiffany,21577 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Henderson, Jackson, A,22121 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Barnes, Brittany, R,15340 | 156.04 | 0.00 | 0.00 | 0.00 | 156.04 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| White, James,25331 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Powell, Lauren, E,19662 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Patterson, Grace, M,27560 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Davis, Justin,28074 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Isla, Julian, A,13732 | 108.96 | 0.00 | 0.00 | 4.99 | 103.97 |
| Price, Stephanie,25892 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martinez, Joseph, E,29214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Hill, Fernando,24763 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bailey, Maria, C,19150 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Evans, Gabriel,23487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Martin, Xavier,22233 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Butler, Cassidy, L,21792 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Lewis, Brianna, H,14282 | 166.24 | 0.00 | 0.00 | 0.00 | 166.24 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Yuan, Carly,19839 | 194.96 | 0.00 | 0.00 | 0.00 | 194.96 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gonzalez, Logan, J,17483 | 64.50 | 0.00 | 0.00 | 0.00 | 64.50 |
| Baker, Ian, V,26200 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Foster, Edward, R,18355 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Cooper, Grace, C,16012 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Phillips, Adam, R,22748 | 4188.24 | 0.00 | 3578.27 | 0.00 | 609.97 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Butler, Dalton, A,13345 | 4759.51 | 0.00 | 0.00 | 0.00 | 4759.51 |
| Hughes, Morgan, T,11642 | 392.89 | 0.00 | 0.00 | 0.00 | 392.89 |
| Perry, Brandon,22095 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Morgan, Juan, C,18821 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Watson, Erin, B,22772 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kumar, Cameron, S,18571 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
Generated 2025-12-24 06:07:39.367 UTC