[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 2 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Srini, Virginia,20048 | 3142.45 | 699.10 | 0.00 | 0.00 | 2443.35 |
| Sanz, Marie,13600 | 8460.25 | 3578.27 | 0.00 | 0.00 | 4881.98 |
| Gao, Claudia,13690 | 7162.08 | 0.00 | 3578.27 | 0.00 | 3583.81 |
| Hernandez, Anne, B,11240 | 7586.23 | 0.00 | 3399.99 | 2369.96 | 1816.28 |
| Taylor, Charles,13792 | 7216.08 | 0.00 | 3578.27 | 0.00 | 3637.81 |
| Alvarez, Danny,13820 | 5908.26 | 0.00 | 3578.27 | 0.00 | 2329.99 |
| He, Lacey,14429 | 8394.29 | 0.00 | 3578.27 | 0.00 | 4816.02 |
| Carlson, Arthur, P,11343 | 8221.99 | 0.00 | 3399.99 | 0.00 | 4822.00 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Martinez, Brandy, L,12865 | 114.23 | 0.00 | 0.00 | 0.00 | 114.23 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Moreno, Craig, N,14158 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Xu, Willie, J,14157 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Carlson, Robyn, M,14183 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 |
| Zeng, Randy, A,11341 | 8192.00 | 0.00 | 3399.99 | 2338.97 | 2453.04 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Jimenez, Jessie,11344 | 8119.81 | 0.00 | 3399.99 | 2297.28 | 2422.54 |
| Edwards, Edward,14700 | 5904.23 | 0.00 | 3578.27 | 0.00 | 2325.96 |
| Serrano, Frank,23232 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Tang, Nicolas, S,12282 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Arthur, Ronald, D,14776 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Chen, Alejandro,14947 | 6658.58 | 0.00 | 3578.27 | 0.00 | 3080.31 |
| Xu, Brendan, L,14937 | 6652.89 | 0.00 | 3578.27 | 0.00 | 3074.62 |
| Hernandez, Maria,14950 | 6709.59 | 0.00 | 3578.27 | 0.00 | 3131.32 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
Generated 2025-12-24 06:28:35.581 UTC