[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 781 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alonso, Kendra, C,16427 | 2975.02 | 0.00 | 0.00 | 2181.56 | 793.46 |
| Ashe, Francisco, W,12335 | 6912.60 | 0.00 | 0.00 | 2049.10 | 4863.50 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Subram, Dominique, S,15620 | 5959.72 | 0.00 | 3578.27 | 0.00 | 2381.45 |
| Munoz, Kristine,16446 | 3093.03 | 0.00 | 0.00 | 2181.56 | 911.47 |
| Anand, Karla,17185 | 6954.57 | 0.00 | 0.00 | 2181.56 | 4773.01 |
| Romero, Juan, A,16324 | 3282.81 | 0.00 | 0.00 | 2443.35 | 839.46 |
| Wu, Kelli, T,15621 | 5977.74 | 0.00 | 3578.27 | 0.00 | 2399.47 |
| Chande, Nina, D,19263 | 1587.41 | 0.00 | 0.00 | 1000.44 | 586.97 |
| Martinez, David, R,20869 | 2542.96 | 0.00 | 0.00 | 782.99 | 1759.97 |
| Sun, Willie,19278 | 1575.42 | 0.00 | 0.00 | 1000.44 | 574.98 |
| Carlson, Gloria, P,15632 | 5245.06 | 0.00 | 3578.27 | 0.00 | 1666.79 |
| Kapoor, Brenda, C,20834 | 2566.95 | 0.00 | 0.00 | 2566.95 | 0.00 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Ramos, Alberto,12239 | 6901.42 | 0.00 | 0.00 | 2071.42 | 4830.00 |
| Suurs, Paul, J,15669 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Dominguez, Ruben,16573 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Huang, Clarence, C,19341 | 3498.78 | 0.00 | 0.00 | 3498.78 | 0.00 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 0.00 | 782.99 | 1764.96 |
| Liang, Crystal, J,11549 | 7023.77 | 0.00 | 3399.99 | 0.00 | 3623.78 |
| Zhang, Colleen, L,16562 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Morris, Caitlin,19416 | 3476.39 | 0.00 | 0.00 | 3476.39 | 0.00 |
| Garcia, Emmanuel, T,12263 | 6829.38 | 0.00 | 0.00 | 2071.42 | 4757.96 |
| Fernandez, Erick, E,15668 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Zheng, Valerie, R,19312 | 1564.70 | 0.00 | 0.00 | 1000.44 | 564.26 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Ashe, Bruce,12264 | 5662.90 | 0.00 | 0.00 | 3292.94 | 2369.96 |
| Kapoor, Johnathan,20576 | 3147.96 | 0.00 | 782.99 | 0.00 | 2364.97 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Rai, Casey, M,19308 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
Generated 2026-01-04 08:55:35.420 UTC