[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 66 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Foster, Eric,22976 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| Sanchez, Mariah, R,19220 | 66.65 | 0.00 | 0.00 | 0.00 | 66.65 |
| Diaz, Elijah,20000 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| 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 |
| 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 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Martin, Brianna, M,23583 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Morris, Richard,20070 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanz, Lori, L,23865 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Chander, Wayne, S,24344 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 0.00 | 409.12 |
| Jones, Madison,24661 | 4181.76 | 0.00 | 3578.27 | 0.00 | 603.49 |
| Cook, Bryce,28640 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Bennett, Seth,24493 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Cooper, Grace, C,16012 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Williams, Edward, D,14274 | 121.56 | 0.00 | 0.00 | 0.00 | 121.56 |
| Green, Gabriella, C,28035 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Smith, Alexandra,28292 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Martin, Brandon, S,21691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Li, Kevin, S,25188 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
Generated 2026-01-04 05:20:20.169 UTC