[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 92 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Harris, Joshua, L,20280 | 95.94 | 0.00 | 0.00 | 0.00 | 95.94 |
| Long, Gavin,13762 | 186.03 | 0.00 | 0.00 | 0.00 | 186.03 |
| Sanders, Isaiah,25873 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzales, Brittany,21710 | 4187.23 | 3578.27 | 0.00 | 0.00 | 608.96 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Taylor, Edward, C,17442 | 319.88 | 0.00 | 0.00 | 0.00 | 319.88 |
| Alexander, Gavin, K,29322 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Peterson, Christina,28976 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Bell, Gabrielle,22373 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Parker, Jordan,21621 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Thomas, Benjamin, J,21295 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Taylor, Tyler, A,12032 | 614.96 | 0.00 | 0.00 | 0.00 | 614.96 |
| Walker, Destiny, M,16996 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Sanchez, Allison,16667 | 41.72 | 0.00 | 0.00 | 0.00 | 41.72 |
| Sanchez, Adrian, L,13179 | 190.17 | 0.00 | 0.00 | 0.00 | 190.17 |
| Perry, Jonathan, T,27026 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Ashe, Alexis, S,19414 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Garcia, Jonathan,18883 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Ruiz, Carrie, D,18644 | 135.44 | 0.00 | 0.00 | 0.00 | 135.44 |
| Peterson, Melissa, S,24995 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Smith, Chloe,17619 | 163.92 | 0.00 | 0.00 | 0.00 | 163.92 |
| Murphy, Brianna, K,28342 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Bennett, Jordyn, L,22230 | 4223.23 | 0.00 | 3578.27 | 0.00 | 644.96 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 34.99 | 616.99 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 0.00 | 170.91 |
Generated 2025-12-22 20:20:28.898 UTC