[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 22 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Andersen, Bridget, K,17792 | 3266.81 | 0.00 | 0.00 | 2443.35 | 823.46 |
| Garcia, Arthur, T,29413 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Shen, Maurice, L,26938 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Zhao, Eugene,12328 | 6792.11 | 0.00 | 0.00 | 2049.10 | 4743.01 |
| Wang, Dawn, L,27152 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sai, Marie, A,24582 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Sai, Roy, J,16038 | 84.25 | 0.00 | 0.00 | 0.00 | 84.25 |
| Anand, Clayton,20890 | 2527.96 | 0.00 | 0.00 | 782.99 | 1744.97 |
| Rai, Alicia, M,28914 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Davis, Ashley,26407 | 126.28 | 0.00 | 0.00 | 0.00 | 126.28 |
| Zhang, Candice, J,23777 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Wang, Alvin,19939 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| James, Gabriella, S,22594 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Alexander, Natalie, A,25760 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Sanz, Pedro,18168 | 6907.55 | 0.00 | 0.00 | 2181.56 | 4725.99 |
| Xie, Mario,13687 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Sun, Trisha,22442 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Tang, Lindsey, C,25308 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Raman, Martin,17709 | 78.95 | 0.00 | 0.00 | 0.00 | 78.95 |
| Jimenez, Joe,19071 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Phillips, Nathan,25537 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| She, Todd,23442 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wu, Crystal, W,22672 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Chen, Jeffery, C,16827 | 7205.36 | 0.00 | 0.00 | 2443.35 | 4762.01 |
| Butler, Blake,13583 | 8375.29 | 3578.27 | 0.00 | 0.00 | 4797.02 |
| Anderson, Cameron, L,16595 | 6901.38 | 0.00 | 0.00 | 2181.56 | 4719.82 |
Generated 2025-12-21 19:44:25.623 UTC