[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hall, Hunter,21288 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Deng, Dawn, L,16439 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Andersen, Lindsay,27142 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Rana, Brenda, F,20794 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Lewis, Fernando,21574 | 124.45 | 0.00 | 0.00 | 0.00 | 124.45 |
| Miller, Jonathan, A,25356 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Hughes, Tristan,11477 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Russell, Isabella, A,11507 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Long, Jacqueline, E,23519 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Garcia, Dylan, L,14646 | 1538.56 | 0.00 | 699.10 | 0.00 | 839.46 |
| Rivera, Timothy, A,21737 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Turner, Angel, L,16278 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 |
| Foster, Luis, R,26009 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Phillips, Sara, A,24227 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
Generated 2025-12-22 04:57:58.559 UTC