[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1203 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Brown, Morgan,29197 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Powell, Vanessa,26630 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Jai, Hunter, M,28272 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Miller, Andrew, C,27110 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perry, Melissa,22128 | 4142.23 | 0.00 | 3578.27 | 0.00 | 563.96 |
| Ross, Anna, D,15494 | 275.44 | 0.00 | 0.00 | 0.00 | 275.44 |
| She, Martha, E,22251 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Washington, Christian, R,26686 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Stewart, Katherine, Z,22901 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Long, Julia, R,22889 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Simmons, James,19884 | 4588.45 | 0.00 | 3399.99 | 0.00 | 1188.46 |
Generated 2025-12-24 06:22:09.304 UTC