[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 655 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 0.00 | 109.95 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Serrano, Albert, E,13328 | 4708.02 | 0.00 | 0.00 | 0.00 | 4708.02 |
| Reed, Judith, D,25347 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 32.60 | 95.20 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Long, Jordan,19988 | 4555.47 | 0.00 | 3399.99 | 0.00 | 1155.48 |
| Sanders, Chloe, C,23137 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Gill, Beth,19997 | 5814.98 | 0.00 | 3374.99 | 0.00 | 2439.99 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 0.00 | 1228.83 |
| Bryant, Isabella, L,22995 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| Harris, Megan,23281 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Powell, Jonathan,23858 | 4712.74 | 0.00 | 3578.27 | 0.00 | 1134.47 |
| Rodriguez, Anthony, G,23829 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Washington, Vanessa,23819 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Rodriguez, Morgan,23730 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Turner, Wyatt,20034 | 5769.96 | 0.00 | 3399.99 | 0.00 | 2369.97 |
| Jones, Madison,24661 | 4181.76 | 0.00 | 3578.27 | 603.49 | 0.00 |
| Walker, Isabella,24386 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Sharma, Yolanda, K,25048 | 3046.84 | 0.00 | 2443.35 | 0.00 | 603.49 |
| Wood, Alexandria, M,24824 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Watson, Kimberly, A,20188 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Hughes, Julia,25061 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Sanders, Paige,25287 | 2983.34 | 0.00 | 2443.35 | 0.00 | 539.99 |
| Turner, Amanda, L,20318 | 3241.90 | 0.00 | 2071.42 | 0.00 | 1170.48 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Flores, Jordyn,25288 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Howard, Isaiah,25981 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Coleman, Lucas, A,27060 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Harris, Edward,27062 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 0.00 | 223.93 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Campbell, Adam, A,21400 | 2688.89 | 0.00 | 0.00 | 2071.42 | 617.47 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Coleman, Ashley,27297 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Kelly, Bryan,21349 | 2989.38 | 0.00 | 0.00 | 2989.38 | 0.00 |
| Baker, Ian, V,26200 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 0.00 | 275.50 |
| Harris, Emily, P,19862 | 98.48 | 0.00 | 0.00 | 0.00 | 98.48 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Ward, Stephanie, A,27429 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Powell, David, W,26615 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Blue, Marcus, L,27550 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Hughes, Brittany,14387 | 898.46 | 0.00 | 0.00 | 0.00 | 898.46 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
Generated 2025-12-24 06:30:43.517 UTC