[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 10 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| King, Gabrielle,26350 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Coleman, Vanessa,21589 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Torres, Haley, W,23283 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Ward, Eduardo, I,13916 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Ross, Haley, T,25361 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Moore, Logan,26348 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Powell, Miranda, J,15304 | 4843.00 | 0.00 | 0.00 | 0.00 | 4843.00 |
| Cox, Katelyn, B,21742 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Wilson, Daniel, K,14281 | 4746.30 | 0.00 | 0.00 | 0.00 | 4746.30 |
| Walker, Thomas,13071 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
Generated 2025-12-21 21:13:14.800 UTC