[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1125 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Dominguez, Dwayne, L,25806 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Foster, Blake, K,13240 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Alexander, Isabelle, L,15992 | 3194.93 | 0.00 | 0.00 | 782.99 | 2411.94 |
| Davis, Logan, H,13445 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Serrano, Marie, C,14201 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Liu, Tiffany, J,18016 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Edwards, Jennifer,12962 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Rai, Bridget, L,17542 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Howard, Julia, S,17552 | 2357.28 | 0.00 | 0.00 | 0.00 | 2357.28 |
| Andersen, Christy, A,27780 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Anderson, Alexandra, L,23857 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Diaz, Cassidy,11847 | 124.97 | 0.00 | 0.00 | 0.00 | 124.97 |
| Mr., Roy, Luke, J.,21286 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Carlson, Jaime, J,17470 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Torres, Eduardo,15314 | 1576.45 | 0.00 | 0.00 | 782.99 | 793.46 |
| Wu, Erica,25452 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Gill, Carrie,28065 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Mehta, Rachael, D,22132 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| James, Bailey, A,22972 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Flores, Hailey, L,22119 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Flores, Angela, B,20028 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Huang, Ronnie,20047 | 614.98 | 0.00 | 0.00 | 0.00 | 614.98 |
| She, Peter, D,20046 | 691.91 | 0.00 | 0.00 | 0.00 | 691.91 |
| Walker, Julia,27217 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Cooper, Zoe, L,27751 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Roberts, Edward, S,25882 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Cox, Jeremy,20331 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Cooper, Bailey,17863 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Ortega, Krista,28548 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Andersen, Alisha,25460 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Deng, Darrell, A,25450 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
Generated 2025-12-22 00:32:38.996 UTC