[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Price, Madison,13282 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| White, William,12157 | 42.95 | 0.00 | 0.00 | 0.00 | 42.95 |
| Rana, Ann, C,25793 | 2479.94 | 0.00 | 0.00 | 2479.94 | 0.00 |
| Peterson, Jasmine, R,26298 | 3340.26 | 0.00 | 0.00 | 2071.42 | 1268.84 |
| Mitchell, Nathan,28634 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Martin, Neil,24078 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Hall, Sydney,12099 | 43.99 | 0.00 | 0.00 | 0.00 | 43.99 |
| Bell, Trinity,27898 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Carlson, Nelson, M,12273 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Gonzalez, Denise, P,27886 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Turner, Richard, A,18965 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Lal, Christian, M,13483 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Gray, Angela, T,15744 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Clark, Lucas,16782 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
| Subram, George, C,20974 | 126.28 | 0.00 | 0.00 | 0.00 | 126.28 |
| Kelly, Grace,17431 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-23 14:31:32.035 UTC