[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 375 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 74.46 | 182.06 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 39.99 | 47.96 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 0.00 | 603.53 |
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Hill, Carlos,12919 | 257.88 | 0.00 | 0.00 | 158.93 | 98.95 |
| Jones, Dalton, T,18951 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 118.96 | 533.02 |
| Stewart, Alexandria,17476 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Martin, Gina, E,11078 | 793.27 | 0.00 | 0.00 | 158.36 | 634.91 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 49.97 | 121.50 |
| Hall, Elizabeth, L,13474 | 339.48 | 0.00 | 0.00 | 0.00 | 339.48 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
Generated 2025-11-06 09:42:14.929 UTC