[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 38 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanz, Leslie, N,13180 | 201.46 | 0.00 | 0.00 | 0.00 | 201.46 |
| Munoz, Tyrone, G,12870 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Hughes, Melanie, A,11985 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 |
| Long, Gabriel,29017 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Clark, Olivia,22081 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Barnes, Caroline,11973 | 88.96 | 0.00 | 0.00 | 0.00 | 88.96 |
| Srini, Lydia, J,28499 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Perez, Jackson, G,29016 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Diaz, Brandi,16424 | 5738.38 | 0.00 | 0.00 | 2181.56 | 3556.82 |
| Hernandez, Amber,16019 | 573.98 | 0.00 | 0.00 | 0.00 | 573.98 |
| Parker, Thomas,27399 | 84.46 | 0.00 | 0.00 | 0.00 | 84.46 |
| Lopez, Gerald, M,25530 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Griffin, Ana,11960 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Brown, Natalie, T,18475 | 616.91 | 0.00 | 0.00 | 0.00 | 616.91 |
Generated 2025-12-22 06:44:45.291 UTC