[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 704 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gutierrez, Arthur, A,12504 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
| Huang, Alvin,12491 | 86.58 | 0.00 | 0.00 | 0.00 | 86.58 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Mehta, Ivan, S,26390 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Alonso, Larry, B,13586 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Martinez, Bryant,19471 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Martin, Gloria, A,12325 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Yuan, Katie,19459 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Luo, Christy,16277 | 3010.03 | 0.00 | 0.00 | 2181.56 | 828.47 |
Generated 2025-12-24 06:06:14.048 UTC