[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 965 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Griffin, Jose, A,11685 | 110.92 | 0.00 | 0.00 | 47.94 | 62.98 |
| Lewis, Nicole,21881 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Russell, Arianna,22728 | 149.93 | 0.00 | 0.00 | 149.93 | 0.00 |
| Alexander, Aaron,20285 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Xu, Terrence, L,23743 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Edwards, Kaitlyn,20372 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Campbell, Haley, L,17304 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Jones, Kaitlyn,15373 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Kumar, Bradley,18176 | 3345.40 | 0.00 | 0.00 | 1000.44 | 2344.96 |
| Sanz, Audrey,21315 | 1189.46 | 0.00 | 0.00 | 0.00 | 1189.46 |
| Griffin, Spencer,13784 | 7138.10 | 3578.27 | 0.00 | 0.00 | 3559.83 |
| Jordan, Gerald, L,19053 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
Generated 2024-11-11 02:04:58.649 UTC