[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 15 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Flores, Logan, K,14631 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Taylor, Victoria,26013 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Roberts, Thomas, J,21939 | 4163.24 | 0.00 | 3578.27 | 0.00 | 584.97 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Johnson, James,23498 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Shan, Chad, M,24621 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Deng, Wayne,21453 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Brown, Julia,18065 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
| Jackson, Brianna,15377 | 97.91 | 0.00 | 0.00 | 0.00 | 97.91 |
| Torres, Dalton,23503 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Turner, Kaylee, M,16213 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 0.00 | 4745.02 |
| Nath, Carl, H,29001 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
Generated 2025-12-24 04:03:00.289 UTC