[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Travers, Brooke,19406 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Alexander, Connor, G,21435 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Ortega, Wendy, B,15094 | 7108.87 | 0.00 | 0.00 | 2181.56 | 4927.31 |
| Collins, Kaylee, M,13657 | 4819.30 | 0.00 | 0.00 | 2443.35 | 2375.95 |
| Xu, Franklin, D,17103 | 6935.08 | 0.00 | 0.00 | 2181.56 | 4753.52 |
| Russell, Caroline, L,11130 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Torres, Philip, S,18941 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Adams, Logan,14466 | 90.47 | 0.00 | 0.00 | 0.00 | 90.47 |
| Carlson, Michele,25648 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Parker, Kevin,20522 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Lu, Aimee, J,20342 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Cook, Cole, W,23197 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Coleman, Elizabeth,11932 | 136.25 | 0.00 | 0.00 | 0.00 | 136.25 |
| Griffin, Austin, K,12095 | 56.93 | 0.00 | 0.00 | 0.00 | 56.93 |
| Kelly, Chloe, M,16999 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Evans, Stephanie, C,20039 | 2457.33 | 0.00 | 0.00 | 2457.33 | 0.00 |
| Miller, Ashley, V,23516 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Shan, Luis,15841 | 3105.27 | 0.00 | 0.00 | 782.99 | 2322.28 |
| Jones, Katherine,22735 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Lewis, Destiny,20376 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Griffin, Kaitlyn,19516 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Diaz, Grace, R,21735 | 94.46 | 0.00 | 0.00 | 0.00 | 94.46 |
| Gonzalez, Cindy,26822 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| James, Isaac,18640 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhou, Kristen, R,23632 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Simmons, Ryan,25148 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Clark, Ashley, H,12398 | 2920.45 | 0.00 | 0.00 | 0.00 | 2920.45 |
| Alan, Kari, A,23601 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Bennett, Sydney,11014 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Phillips, Connor, E,23154 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
Generated 2025-12-22 05:55:00.511 UTC