[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 953 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Price, Mariah, C,20745 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Flores, Hannah,19525 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Peterson, Christina,28976 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Sánchez, Angela, C,17655 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Thomas, Megan,29071 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Edwards, Hailey,24258 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jai, Jose,12944 | 164.21 | 0.00 | 0.00 | 0.00 | 164.21 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Thomas, Richard,27557 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Moore, Ian, L,24639 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Thomas,21629 | 2624.08 | 0.00 | 0.00 | 2049.10 | 574.98 |
| Collins, Allison,28581 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
Generated 2025-12-22 02:07:26.584 UTC