[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Phillips, Aaron, R,24947 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Li, Rafael, M,21752 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Turner, Adam, K,16109 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Hayes, Hannah, J,21656 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Reed, Judith, D,25347 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 71.97 | 128.97 |
| Long, Julia, R,22889 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Ward, Lucas, N,18363 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Phillips, Jackson, D,23378 | 5317.23 | 0.00 | 3578.27 | 0.00 | 1738.96 |
| Rivera, Sara,18785 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Anand, Brendan, L,19847 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Brown, Jonathan,11875 | 265.42 | 0.00 | 0.00 | 0.00 | 265.42 |
| Hughes, Miranda,26678 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
| Lopez, Eduardo, J,26640 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Miller, Eduardo,14561 | 158.84 | 0.00 | 0.00 | 49.97 | 108.87 |
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 60.47 | 172.24 |
| Brooks, Allison,14605 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 99.97 | 126.46 |
| Johnson, Christopher,11979 | 4813.76 | 0.00 | 0.00 | 2352.21 | 2461.55 |
| Wagner, Alexandra, E,23244 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Campbell, Wyatt, C,27602 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Wilson, Madison, H,19828 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Barnes, Brittany, R,15340 | 156.04 | 0.00 | 0.00 | 74.46 | 81.58 |
| Powell, Vanessa,26630 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 676.93 | 0.00 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
| Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 0.00 | 282.04 |
| Lewis, Christopher,18755 | 86.96 | 0.00 | 0.00 | 86.96 | 0.00 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Lal, Jonathan,20096 | 71.46 | 0.00 | 0.00 | 0.00 | 71.46 |
| Liu, Arturo,13222 | 150.41 | 0.00 | 0.00 | 13.98 | 136.43 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 112.25 | 27.92 |
| Sharma, Samuel,27725 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Stewart, Destiny,13144 | 281.47 | 0.00 | 0.00 | 134.98 | 146.49 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Wilson, Grace,17539 | 205.92 | 0.00 | 0.00 | 0.00 | 205.92 |
| Nelson, James, L,24525 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Brooks, Lucas, S,16089 | 342.03 | 0.00 | 0.00 | 0.00 | 342.03 |
| Flores, Madison,14416 | 769.49 | 0.00 | 0.00 | 0.00 | 769.49 |
| Sanchez, Martin, E,21631 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Morris, Chase, F,26789 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Alexander, Angelica,22714 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Hughes, Riley,29284 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 21.49 | 304.40 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Garcia, Isabella,18382 | 204.94 | 0.00 | 0.00 | 0.00 | 204.94 |
| Alexander, Paige, W,18604 | 59.25 | 0.00 | 0.00 | 37.27 | 21.98 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Foster, Caleb,27112 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Lee, Alexander, S,18356 | 149.91 | 0.00 | 0.00 | 0.00 | 149.91 |
| Long, Jordyn,17338 | 47.25 | 0.00 | 0.00 | 0.00 | 47.25 |
| Flores, Caleb, S,12165 | 280.64 | 0.00 | 0.00 | 243.37 | 37.27 |
| Robinson, William,20103 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Flores, Isabelle, A,15526 | 188.32 | 0.00 | 0.00 | 96.07 | 92.25 |
| Stewart, Amanda, M,15310 | 94.44 | 0.00 | 0.00 | 0.00 | 94.44 |
| Griffin, Haley, L,18925 | 82.18 | 0.00 | 0.00 | 0.00 | 82.18 |
| Reed, Kaitlyn, H,27413 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Harris, Edward,27062 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Collins, Xavier, C,16646 | 250.91 | 0.00 | 0.00 | 0.00 | 250.91 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Rogers, Jade, I,14332 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Perez, Kaitlyn, A,12081 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Butler, Morgan, E,20500 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Carter, Jesse, E,22141 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Mitchell, Evan, R,24731 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
| Rivera, Rachel, S,28996 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Collins, Nathan, F,19704 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Campbell, Adam, A,21400 | 2688.89 | 0.00 | 0.00 | 2071.42 | 617.47 |
| Patterson, Natalie,16123 | 629.97 | 0.00 | 0.00 | 0.00 | 629.97 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Green, Gabriella, C,28035 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Adams, Mason, T,20528 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Prasad, Donald,15413 | 318.92 | 0.00 | 0.00 | 123.98 | 194.94 |
| Sanders, Lucas, W,26802 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Taylor, Brianna,17027 | 230.90 | 0.00 | 0.00 | 145.42 | 85.48 |
| Griffin, Cassidy,26496 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| James, Richard, D,15760 | 109.23 | 0.00 | 0.00 | 3.99 | 105.24 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 34.98 | 240.52 |
| Dominguez, Erika, C,21251 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Parker, Jordan,21621 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Taylor, Edward, C,17442 | 319.88 | 0.00 | 0.00 | 230.90 | 88.98 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Roberts, Seth, H,11510 | 258.15 | 0.00 | 0.00 | 39.47 | 218.68 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 1000.44 | 0.00 | 0.00 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Carter, Marcus, l,21471 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Diaz, Brandon,23676 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Alexander, Julian,13217 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 0.00 | 2049.10 | 2359.46 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Powell, Elijah, E,23113 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Washington, Emma,19123 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Hall, Charles,23476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Young, Julia, J,27414 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Jordan, K,14458 | 133.95 | 0.00 | 0.00 | 0.00 | 133.95 |
| Robinson, Madison, W,18377 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
Generated 2025-11-01 00:04:44.715 UTC