[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 26 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Deng, Kathryn,15521 | 3172.95 | 0.00 | 0.00 | 782.99 | 2389.96 |
| Lopez, Rebecca, F,27504 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Zeng, Glenn, A,25306 | 1769.96 | 0.00 | 0.00 | 0.00 | 1769.96 |
| Andersen, Dustin, L,26684 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Washington, Luke,21237 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Pedro, J,12954 | 51.27 | 0.00 | 0.00 | 0.00 | 51.27 |
| Cook, Brianna, E,29132 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Malhotra, Cassandra, L,25756 | 2493.54 | 0.00 | 0.00 | 0.00 | 2493.54 |
| Malhotra, Jarrod, E,27316 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| King, Edward,17430 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Erik, W,15194 | 3173.94 | 0.00 | 782.99 | 0.00 | 2390.95 |
| Jenkins, Robert, Z,15546 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-23 06:51:34.158 UTC