[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 28 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
| Yuan, Carly,19839 | 194.96 | 0.00 | 0.00 | 0.00 | 194.96 |
| Hernandez, Eduardo, J,18919 | 300.94 | 0.00 | 0.00 | 0.00 | 300.94 |
| Morris, Haley, A,23548 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Long, Julia, R,22889 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Jai, Edwin,16921 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Lal, Caleb, R,15868 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Bennett, Brittany, J,22332 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Thomas,21629 | 2624.08 | 0.00 | 0.00 | 2049.10 | 574.98 |
| Wilson, Andrew, R,18236 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Alexander, Edward, E,18524 | 195.95 | 0.00 | 0.00 | 0.00 | 195.95 |
| Wagner, Alexandra, E,23244 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Nicholas,23362 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Allen, Jack, M,29137 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Coleman, Vanessa,21589 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
Generated 2025-12-24 05:05:57.536 UTC