[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 655 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Harris, Seth, M,16140 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Perez, Katherine, J,22079 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Parker, Blake,15008 | 170.53 | 0.00 | 0.00 | 0.00 | 170.53 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 0.00 | 273.90 |
| Phillips, Jack, R,25995 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Jones, Kayla, C,18541 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Jai, Connor, D,27253 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Brooks, Allison,14605 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Hill, Katherine, L,26701 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cooper, Brianna,25925 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Turner, Andrea, A,20209 | 3268.55 | 0.00 | 2049.10 | 0.00 | 1219.45 |
| Moreno, Meredith, D,22285 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Phillips, Kaylee,21138 | 4371.38 | 0.00 | 0.00 | 2049.10 | 2322.28 |
| Wright, Jackson,11698 | 225.95 | 0.00 | 0.00 | 0.00 | 225.95 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Brown, Christian,22755 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alexander, Angelica,22714 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Edwards, Connor,16950 | 211.01 | 0.00 | 0.00 | 0.00 | 211.01 |
| Thomas, Jeremiah,18372 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 0.00 | 4793.02 |
| Coleman, Ashley,27297 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Reed, Michelle,28046 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Walker, Richard, T,19640 | 224.55 | 0.00 | 0.00 | 0.00 | 224.55 |
| Johnson, Anthony, D,27022 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
Generated 2025-12-23 11:55:31.890 UTC