[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1038 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nelson, Natalie, C,22928 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Moore, Emily, W,14350 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Ward, Mackenzie, D,21130 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Dominguez, Anne,13258 | 8886.53 | 3578.27 | 0.00 | 0.00 | 5308.26 |
| Srini, Chelsea, S,17930 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Cooper, Cody, A,16028 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Alexander, Grace, J,24074 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
Generated 2025-12-24 07:04:07.509 UTC