[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 89 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Flores, Caleb, S,12165 | 280.64 | 0.00 | 0.00 | 159.47 | 121.17 |
| Hughes, Riley,29284 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Hayes, Jeremiah, W,20086 | 128.55 | 0.00 | 0.00 | 0.00 | 128.55 |
| Collins, Isaac,26077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hernandez, Eduardo, J,18919 | 300.94 | 0.00 | 0.00 | 0.00 | 300.94 |
| Collins, Alex, S,28781 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Rubio, Javier, E,19726 | 64.24 | 0.00 | 0.00 | 0.00 | 64.24 |
| Garcia, Brandon, V,24418 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Butler, Trevor,27415 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
Generated 2025-12-21 14:40:45.508 UTC