[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Davis, Rachel, T,14404 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jenkins, Alyssa, L,27755 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Clark, Brandon, C,21485 | 1149.47 | 0.00 | 0.00 | 0.00 | 1149.47 |
| Coleman, Miranda,17620 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Prasad, Lydia,17117 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chen, Damien, A,23979 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ye, Jeffery, Y,28572 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Rana, Edgar, M,28379 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Guo, Suzanne,25507 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gill, Marc,12974 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hughes, Wyatt, H,26872 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Li, Colleen, H,16569 | 3936.54 | 0.00 | 0.00 | 3936.54 | 0.00 |
| Collins, Marcus,22262 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Gao, Franklin, R,13797 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2025-12-22 06:43:45.549 UTC