[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 971 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Malhotra, Arthur, E,25267 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Suarez, Tyrone,15684 | 6963.07 | 0.00 | 2181.56 | 0.00 | 4781.51 |
| Cox, Kaylee,23800 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Mr., Shimshoni, Daniel,24705 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Jai, Elijah,23443 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Wang, Eric,14409 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
Generated 2024-11-11 07:18:47.382 UTC