[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 27 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Lance,12614 | 5918.24 | 0.00 | 3578.27 | 0.00 | 2339.97 |
| Martinez, William, A,25082 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Lal, Jose,11819 | 96.27 | 0.00 | 0.00 | 0.00 | 96.27 |
| Lal, Louis, M,26184 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Hughes, Emily,18123 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Bruce, D,27936 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gomez, Francis, T,22084 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Turner, Natalie,17441 | 2404.95 | 0.00 | 0.00 | 0.00 | 2404.95 |
| Nara, Russell,12629 | 53.97 | 0.00 | 0.00 | 0.00 | 53.97 |
| Munoz, Dwayne, F,24091 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Sanders, Marcus, J,13186 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Gonzales, Caroline,27576 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
Generated 2025-12-22 04:18:57.588 UTC