[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 16 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzales, Jocelyn,29212 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Long, Gavin,13762 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Ramirez, Sara, A,12757 | 106.96 | 0.00 | 0.00 | 0.00 | 106.96 |
| Chapman, Shaun, K,12397 | 4968.04 | 0.00 | 0.00 | 4379.08 | 588.96 |
| Ramirez, Faith,29198 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Martin, Ryan,15360 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Adams, Jackson, H,17449 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Li, Ronnie,15650 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Watson, Lucas,16992 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hall, Dalton,20544 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Rodriguez, Johnathan, A,17973 | 1852.26 | 0.00 | 0.00 | 0.00 | 1852.26 |
| Sai, Meredith,14139 | 819.48 | 0.00 | 0.00 | 0.00 | 819.48 |
| Andersen, Russell,14695 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Sanders, Nathaniel, L,14619 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Baker, Courtney, A,18988 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2025-12-22 08:29:02.444 UTC