[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 51 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sharma, Colleen,13215 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Patterson, Nathan, W,17532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Coleman, Richard,13233 | 4587.51 | 0.00 | 0.00 | 2181.56 | 2405.95 |
| Martin, Erik,27176 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Ross, Jeremiah, L,15403 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Mallory, A,19281 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Raji, Tony, K,27332 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2025-12-23 03:50:53.874 UTC