[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Linda,17758 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Alexander, Brianna,14503 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gill, Kendra, H,12236 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Sanchez, Kristopher, D,17759 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Hughes, Mariah, A,24435 | 46.83 | 0.00 | 0.00 | 0.00 | 46.83 |
| Evans, Caleb, S,16072 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Chen, Eugene, L,28376 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
| Gray, Melanie, S,20355 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gray, Brian,26729 | 4442.16 | 0.00 | 0.00 | 2049.10 | 2393.06 |
| Morris, Steven,27425 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Huang, Heather,26276 | 3361.92 | 0.00 | 2049.10 | 0.00 | 1312.82 |
| Jenkins, Haley, L,22337 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Chow, Todd,21849 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzales, Caroline,27576 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
Generated 2025-12-22 05:56:02.179 UTC