[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 34 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rubio, Mathew,11933 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Shan, Luke,13365 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Foster, Jonathan,22186 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Tang, Mario, T,13167 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Stewart, Chase,12810 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chandra, Francisco, A,12440 | 5913.25 | 0.00 | 3578.27 | 0.00 | 2334.98 |
| Gonzales, James, L,12413 | 162.28 | 0.00 | 0.00 | 0.00 | 162.28 |
| Simmons, Nathan, M,11043 | 47.98 | 0.00 | 0.00 | 0.00 | 47.98 |
| Madan, Cesar, E,11608 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| She, Leonard, S,22797 | 2309.97 | 0.00 | 0.00 | 0.00 | 2309.97 |
| Bryant, Luis, D,21646 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Rogers, Destiny,11626 | 5958.74 | 0.00 | 3578.27 | 0.00 | 2380.47 |
Generated 2025-12-22 09:40:59.987 UTC