[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 25 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shan, Gabriel, T,27731 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 0.00 | 699.97 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 0.00 | 676.93 |
| Perry, Natalie,17126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| James, Zoe, R,14611 | 304.55 | 0.00 | 0.00 | 0.00 | 304.55 |
| Campbell, Hailey,15507 | 267.84 | 0.00 | 0.00 | 228.96 | 38.88 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 0.00 | 223.93 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 74.98 | 65.19 |
| Collins, Eduardo,13987 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Coleman, Ian,21276 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Robinson, Joseph,28141 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Adams, Mackenzie, A,14640 | 812.42 | 0.00 | 0.00 | 0.00 | 812.42 |
| Gonzalez, Madeline, B,18922 | 2326.96 | 0.00 | 0.00 | 0.00 | 2326.96 |
| Ortega, Javier, P,12785 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
| Bennett, Seth,24493 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Henderson, Caroline,20082 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Lewis, Isabella,26242 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Perry, Jennifer, J,22120 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Chandra, Allen,29327 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
Generated 2025-12-22 12:13:43.896 UTC