[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 985 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Carter, Edward,23824 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Xu, Yolanda, E,15893 | 1428.94 | 0.00 | 0.00 | 782.99 | 645.95 |
| Coleman, Elijah,23695 | 150.93 | 0.00 | 0.00 | 150.93 | 0.00 |
| Jones, Tyler,27446 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Ye, Jessie, J,14145 | 24.27 | 0.00 | 0.00 | 24.27 | 0.00 |
| Garcia, John, M,16432 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Li, Christy,16539 | 83.97 | 0.00 | 0.00 | 83.97 | 0.00 |
| Goel, Maurice,11410 | 4464.07 | 0.00 | 0.00 | 4464.07 | 0.00 |
| Moreno, Kendra,20138 | 119.96 | 0.00 | 0.00 | 119.96 | 0.00 |
| Coleman, Mya,27418 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Hernandez, Rebecca,20944 | 226.49 | 0.00 | 0.00 | 226.49 | 0.00 |
| Bennett, Janice,15904 | 1394.95 | 0.00 | 0.00 | 782.99 | 611.96 |
| Patel, George,26414 | 58.47 | 0.00 | 0.00 | 58.47 | 0.00 |
| Huang, Alisha, E,17780 | 4112.77 | 0.00 | 0.00 | 1000.44 | 3112.33 |
| Campbell, Jonathan, D,12784 | 5985.22 | 0.00 | 3578.27 | 0.00 | 2406.95 |
Generated 2024-11-10 17:38:29.618 UTC