[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 0 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jenkins, Gabrielle, B,21659 | 4143.74 | 3578.27 | 0.00 | 0.00 | 565.47 |
| Gonzales, Brittany,21710 | 4187.23 | 3578.27 | 0.00 | 0.00 | 608.96 |
| Sanders, Alexa, E,21741 | 4127.25 | 3578.27 | 0.00 | 548.98 | 0.00 |
| Flores, Arianna,21727 | 4132.24 | 3578.27 | 0.00 | 0.00 | 553.97 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 160.51 | 764.10 |
| Edwards, Eric,24627 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 0.00 | 272.69 |
| Hall, Morgan,21726 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Ye, Alisha, J,22008 | 4141.23 | 3578.27 | 0.00 | 0.00 | 562.96 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 69.97 | 85.48 |
| Perez, Sydney, C,22117 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Powell, Vanessa,26630 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Watson, Shelby, J,14911 | 867.97 | 0.00 | 0.00 | 0.00 | 867.97 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
Generated 2025-11-06 05:52:29.554 UTC