[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 655 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Alejandro,12213 | 4419.06 | 0.00 | 0.00 | 2049.10 | 2369.96 |
| Sanchez, Riley, J,26491 | 4469.44 | 0.00 | 0.00 | 2049.10 | 2420.34 |
| Hill, Elijah, E,18069 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ward, Amanda,13714 | 3033.31 | 0.00 | 0.00 | 2443.35 | 589.96 |
| Ross, Luis,20865 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Bennett, Wyatt, J,13658 | 4787.61 | 0.00 | 0.00 | 2443.35 | 2344.26 |
| Srini, Bruce, D,20978 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patel, Brandy,22314 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Mitchell, Blake,13705 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Lin, Micah,19292 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Carlson, Nelson, M,12273 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Li, Aaron,15429 | 3170.20 | 0.00 | 0.00 | 782.99 | 2387.21 |
| Perez, Wyatt,26537 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Gonzalez, Kyle, J,26601 | 2862.74 | 0.00 | 0.00 | 2071.42 | 791.32 |
| Ortega, Kathleen, G,12225 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
Generated 2025-12-24 06:10:04.640 UTC