[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Howard, Alyssa, A,11513 | 863.95 | 0.00 | 0.00 | 0.00 | 863.95 |
| Green, Gabrielle, M,21815 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Zhao, Clarence, R,19826 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Anderson, Isabella,13743 | 2349.98 | 0.00 | 0.00 | 0.00 | 2349.98 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Coleman, Luke, A,11723 | 152.55 | 0.00 | 0.00 | 39.99 | 112.56 |
| Edwards, Alexandra,13358 | 2386.94 | 0.00 | 0.00 | 0.00 | 2386.94 |
| Henderson, Abigail,20441 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Miller, Kayla, A,23673 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Lu, Alejandro,25620 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morris, Chase, F,26789 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
Generated 2025-12-23 09:12:00.463 UTC