[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Gonzales, Ashley, C,18600 | 51.97 | 0.00 | 0.00 | 21.98 | 29.99 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| Brown, Anna,16247 | 95.82 | 0.00 | 0.00 | 0.00 | 95.82 |
| Green, Marcus, C,15974 | 208.41 | 0.00 | 0.00 | 91.95 | 116.46 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Sanchez, Alex, K,13101 | 4736.03 | 0.00 | 0.00 | 2351.96 | 2384.07 |
| Diaz, Luis, D,11203 | 801.77 | 0.00 | 0.00 | 469.77 | 332.00 |
| Henderson, Gabrielle, B,18603 | 1205.47 | 0.00 | 0.00 | 1205.47 | 0.00 |
| Flores, Logan, K,14631 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Ward, Angela, M,27756 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Nicole,19729 | 37.27 | 0.00 | 0.00 | 32.28 | 4.99 |
| Stewart, Jessica,16097 | 103.55 | 0.00 | 0.00 | 46.58 | 56.97 |
Generated 2026-07-23 08:31:19.845 UTC