[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 220 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Richardson, Arianna, C,12055 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Green, Marcus, C,15974 | 208.41 | 0.00 | 0.00 | 91.95 | 116.46 |
| Bennett, Antonio, C,11631 | 707.50 | 0.00 | 0.00 | 216.34 | 491.16 |
| Perry, Samuel,18811 | 100.96 | 0.00 | 0.00 | 100.96 | 0.00 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 76.95 | 93.96 |
| Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 86.56 | 85.48 |
| Edwards, Mackenzie, K,23458 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Miller, Eduardo,14561 | 158.84 | 0.00 | 0.00 | 49.97 | 108.87 |
| Peterson, Jared,11502 | 829.37 | 0.00 | 0.00 | 171.95 | 657.42 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 0.00 | 603.53 |
| Gray, Cindy, A,13198 | 114.95 | 0.00 | 0.00 | 99.97 | 14.98 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 133.96 | 84.95 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 68.97 | 54.97 |
| Flores, Morgan,19817 | 118.94 | 0.00 | 0.00 | 39.98 | 78.96 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 219.26 | 789.98 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 66.26 | 773.89 |
| Gonzales, Miranda,11660 | 324.72 | 0.00 | 0.00 | 0.00 | 324.72 |
| Diaz, Richard, A,26682 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Garcia, Christian, J,16491 | 3106.33 | 0.00 | 0.00 | 751.34 | 2354.99 |
| Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
| James, Maria,16243 | 91.97 | 0.00 | 0.00 | 69.99 | 21.98 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 32.27 | 189.96 |
| Li, Jordan,17026 | 261.39 | 0.00 | 0.00 | 261.39 | 0.00 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 23.97 | 194.96 |
| Harris, Samuel, M,24771 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Phillips, Mackenzie,12444 | 228.43 | 0.00 | 0.00 | 113.96 | 114.47 |
| Smith, Zachary, W,23783 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
Generated 2025-11-04 14:56:46.467 UTC