[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 250 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| James, Julia,24975 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Kelly, Haley,15511 | 128.56 | 0.00 | 0.00 | 0.00 | 128.56 |
| Wright, Carol, C,12928 | 247.41 | 0.00 | 0.00 | 33.98 | 213.43 |
| She, Shawn, J,16902 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Yuan, Leonard, F,16791 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 39.99 | 47.96 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 0.00 | 109.95 |
| King, Gabrielle,26350 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Williams, Austin,20354 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Bennett, Isabelle, C,18674 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Phillips, Luis, G,20734 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chow, Candice,19232 | 60.96 | 0.00 | 0.00 | 0.00 | 60.96 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Henderson, Jackson, A,22121 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
Generated 2025-11-04 14:56:24.634 UTC