[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 8 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Foster, Emma,15468 | 436.35 | 0.00 | 0.00 | 0.00 | 436.35 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Griffin, Jack, L,17686 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Rodriguez, Anthony, G,23829 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Bell, Chase,18091 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Morris, Chase, F,26789 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 31.27 | 808.88 |
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 0.00 | 214.35 |
| Turner, Amanda, L,20318 | 3241.90 | 0.00 | 2071.42 | 0.00 | 1170.48 |
| Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 0.00 | 282.04 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Raje, Mindy, A,16083 | 561.97 | 0.00 | 0.00 | 0.00 | 561.97 |
| White, James,25331 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Phillips, Devin,18759 | 112.06 | 0.00 | 0.00 | 0.00 | 112.06 |
| White, Emma, N,16090 | 604.96 | 0.00 | 0.00 | 0.00 | 604.96 |
| Peterson, Kaitlyn, S,13706 | 2337.27 | 0.00 | 0.00 | 0.00 | 2337.27 |
| Taylor, Tyler, A,12032 | 614.96 | 0.00 | 0.00 | 0.00 | 614.96 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
Generated 2025-12-23 21:20:53.341 UTC