[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 42 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Vazquez, Cheryl, A,17948 | 3045.30 | 0.00 | 0.00 | 2443.35 | 601.95 |
| Ruiz, Kendra,25598 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rodriguez, Ann, S,12315 | 6803.13 | 0.00 | 0.00 | 4468.16 | 2334.97 |
| Rubio, Clinton, A,25612 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Gill, Kristi, A,27171 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Anderson, Cameron, L,16595 | 6901.38 | 0.00 | 0.00 | 2181.56 | 4719.82 |
| Shen, Bethany, C,17903 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Luo, Gregory,17642 | 32.95 | 0.00 | 0.00 | 0.00 | 32.95 |
| Kelly, Olivia, L,12391 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Lopez, Emmanuel, R,12559 | 5633.91 | 0.00 | 0.00 | 2049.10 | 3584.81 |
| Evans, Lucas, J,11556 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Hill, Nathan,12615 | 5663.23 | 0.00 | 0.00 | 2071.42 | 3591.81 |
| Deng, Corey,28921 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| She, Todd,23442 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gutierrez, Eddie, R,28370 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Tang, Jaclyn, K,21060 | 2508.47 | 0.00 | 0.00 | 782.99 | 1725.48 |
| Moreno, Carrie, W,27151 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Xie, Franklin, A,17747 | 2743.53 | 0.00 | 0.00 | 2181.56 | 561.97 |
| Miller, Olivia, H,26860 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Nath, Tonya,24847 | 2552.82 | 0.00 | 0.00 | 0.00 | 2552.82 |
| Rubio, Dwayne, D,28527 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Yuan, Kurt,16561 | 3030.03 | 0.00 | 0.00 | 2181.56 | 848.47 |
| Garcia, Marie,27953 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Li, Leah,12871 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Morgan, Makayla, C,27156 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
Generated 2025-12-24 05:50:46.546 UTC