[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 765 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Vincent, A,28516 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Vance, Ebony,20724 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Patel, Stefanie,27967 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Raman, Francisco, M,24020 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lal, Jerry, L,27822 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Chen, Alejandro,14947 | 6658.58 | 0.00 | 3578.27 | 0.00 | 3080.31 |
| Chander, Peter, L,14836 | 115.25 | 0.00 | 0.00 | 0.00 | 115.25 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Hayes, Marcus, A,15657 | 5251.34 | 0.00 | 3578.27 | 0.00 | 1673.07 |
| Martin, Paula, B,21855 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Pal, Jon, H,15440 | 6736.56 | 0.00 | 3578.27 | 0.00 | 3158.29 |
| Scott, Dalton,14975 | 5957.22 | 0.00 | 3578.27 | 0.00 | 2378.95 |
| Cox, Melanie, C,12496 | 204.58 | 0.00 | 0.00 | 0.00 | 204.58 |
| Subram, Levi,15619 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Patterson, Margaret, J,13507 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Kapoor, George, L,13676 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Lopez, Jermaine,11488 | 8090.33 | 0.00 | 3374.99 | 2322.28 | 2393.06 |
| Zhao, Edwin,14991 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Ruiz, Jaime, J,25609 | 565.47 | 0.00 | 0.00 | 565.47 | 0.00 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 0.00 | 4752.52 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Arun, Henry, L,27177 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Perez, Andre,11491 | 8158.01 | 0.00 | 3374.99 | 0.00 | 4783.02 |
| Ye, Sandra,24689 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Srini, Whitney,11560 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Ortega, Gary,11496 | 7013.79 | 0.00 | 3399.99 | 2398.95 | 1214.85 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Shan, Carly,18631 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Raman, Darren, K,22315 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-23 07:19:13.290 UTC