[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Nara, Carl, K,12971 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 | 0.00 |
| Zhao, Barbara,16723 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Green, Katherine, J,15949 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 | 0.00 |
| Jiménez, Anne,27012 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 | 0.00 |
| Torres, Marvin, J,27885 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 | 0.00 |
| Garcia, Megan, F,16242 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Watson, Cole, A,21768 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 | 0.00 |
| Turner, Janet, M,17130 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 | 0.00 |
| Chander, Maurice, L,14086 | 70.15 | 0.00 | 0.00 | 0.00 | 70.15 | 0.00 |
| Xu, Kelli, T,21628 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 | 0.00 |
| Edwards, Fernando,23185 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 | 0.00 |
| Lewis, Taylor, G,11295 | 6058.25 | 0.00 | 3578.27 | 2479.98 | 0.00 | 0.00 |
| Lin, Cedric, C,13147 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 | 0.00 |
| Luo, Louis,11465 | 8158.04 | 0.00 | 3399.99 | 0.00 | 4758.05 | 0.00 |
| Ms., Smith, Peggy, R.,28560 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 | 0.00 |
| Morris, Steven,27425 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 | 0.00 |
| Malhotra, Erick, A,28405 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Patterson, Melanie,28898 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 | 0.00 |
| Edwards, Samuel,12024 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 | 0.00 |
| Yuan, Alvin,25651 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 | 0.00 |
| Wang, Gabriel,11163 | 46.27 | 0.00 | 0.00 | 0.00 | 46.27 | 0.00 |
| Lal, Jerry, L,27822 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 | 0.00 |
| Fernandez, Roy, S,15444 | 138.95 | 0.00 | 0.00 | 0.00 | 138.95 | 0.00 |
| Raje, Arturo, C,14228 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 | 0.00 |
| Ross, Kyle,22057 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| Lin, Susan, L,27005 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 | 0.00 |
| Scott, Alex, T,14348 | 2989.38 | 0.00 | 0.00 | 2071.42 | 917.96 | 0.00 |
| Gray, Zoe, F,23482 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 | 0.00 |
Generated 2026-01-04 03:53:52.829 UTC