[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1218 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Johnson, Alexis, J,16075 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Deng, Andres,13667 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Moore, Edward, A,15988 | 89.91 | 0.00 | 0.00 | 0.00 | 89.91 |
| Coleman, Marcus, J,28663 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Luo, Kathryn,27333 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Adams, Isaac,26174 | 2071.42 | 0.00 | 2071.42 | 0.00 | 0.00 |
| Clark, Nathan,12432 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Foster, Julia, A,26238 | 3298.94 | 0.00 | 2049.10 | 0.00 | 1249.84 |
| Wilson, Marcus, L,12975 | 4618.53 | 0.00 | 2181.56 | 0.00 | 2436.97 |
| Watson, Dalton, P,26201 | 4498.46 | 0.00 | 2071.42 | 0.00 | 2427.04 |
| Huang, Edwin,15195 | 3154.95 | 0.00 | 782.99 | 0.00 | 2371.96 |
| Schmidt, Ruth, L,28506 | 3213.57 | 0.00 | 2049.10 | 0.00 | 1164.47 |
| Harris, Grace, L,12930 | 4513.84 | 0.00 | 2181.56 | 0.00 | 2332.28 |
| Butler, Jordyn,13083 | 4532.52 | 0.00 | 2181.56 | 0.00 | 2350.96 |
| Perry, Antonio, L,26234 | 3292.94 | 0.00 | 2049.10 | 0.00 | 1243.84 |
Generated 2025-12-23 09:10:22.115 UTC