[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 282 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jackson, Elizabeth, K,16837 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Foster, Nicole, A,23494 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Howard, Danielle,28357 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Thomas, David,16836 | 3193.79 | 0.00 | 0.00 | 0.00 | 3193.79 |
| Ross, Kelly,26076 | 76.96 | 0.00 | 0.00 | 0.00 | 76.96 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
| James, Morgan, E,23245 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lee, John,19801 | 193.01 | 0.00 | 0.00 | 0.00 | 193.01 |
| Alexander, Julian,13217 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Bryant, Connor,23842 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Gonzales, Ryan, M,17373 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Stewart, Sara,17347 | 119.72 | 0.00 | 0.00 | 0.00 | 119.72 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 0.00 | 325.89 |
Generated 2026-01-04 05:15:45.781 UTC