[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 922 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cox, Lucas, J,25393 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Brown, Benjamin, D,15187 | 4725.32 | 0.00 | 0.00 | 0.00 | 4725.32 |
| Cook, Steven, J,27053 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Coleman, Lucas, A,27060 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cook, Bryce,28640 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Coleman, Wyatt, M,23284 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Turner, Blake,12136 | 131.74 | 0.00 | 0.00 | 0.00 | 131.74 |
| Russell, Xavier,12964 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Smith, Andrew,14723 | 87.57 | 0.00 | 0.00 | 0.00 | 87.57 |
| Johnson, Edward, H,23279 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Wright, Kyle,23716 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Rodriguez, Michael, E,16810 | 3064.63 | 0.00 | 0.00 | 0.00 | 3064.63 |
Generated 2025-12-23 16:41:47.862 UTC