[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Hill, Timothy,14871 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| She, Martha, E,22251 | 5971.33 | 3578.27 | 0.00 | 0.00 | 2393.06 |
| Price, Oscar, G,11833 | 240.01 | 0.00 | 0.00 | 13.98 | 226.03 |
| Wright, Carol, C,12928 | 247.41 | 0.00 | 0.00 | 128.46 | 118.95 |
| Watson, Richard,15943 | 365.41 | 0.00 | 0.00 | 236.44 | 128.97 |
| Carter, Jesse, E,22141 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Nelson, Kevin,14765 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Henderson, Hailey, C,17148 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 32.28 | 4.99 |
| Evans, Connor, J,15402 | 131.55 | 0.00 | 0.00 | 74.98 | 56.57 |
| Hayes, Luis,12880 | 200.73 | 0.00 | 0.00 | 37.27 | 163.46 |
| Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
| Bell, Gabrielle,22373 | 5976.32 | 3578.27 | 0.00 | 0.00 | 2398.05 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 73.54 | 107.25 |
Generated 2026-07-22 22:32:08.705 UTC