[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Marshall, K,25747 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Malhotra, Evelyn,12853 | 4354.08 | 0.00 | 0.00 | 2049.10 | 2304.98 |
| Zhao, Omar,27927 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Perry, Sydney, C,14963 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 0.00 | 62.76 |
| Xie, Melvin,28426 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Ruiz, Pedro,24034 | 1203.46 | 0.00 | 0.00 | 0.00 | 1203.46 |
| Moreno, Francis, A,26962 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| She, Gilbert,19505 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Raman, Andre, D,24079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 0.00 | 57.95 |
| Deng, Dustin, F,11422 | 7075.27 | 0.00 | 3399.99 | 2334.98 | 1340.30 |
| Scott, Mackenzie, L,25676 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Muñoz, Armando, E,19906 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
| Gonzales, Katherine, R,13408 | 6792.12 | 0.00 | 0.00 | 2049.10 | 4743.02 |
| Shen, Maurice, L,26938 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Gill, Darren, M,11408 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Romero, Jaime, B,28508 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Vance, Gerald, M,27841 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Browning, Casey,16449 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Chandra, Ronald, H,20801 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Hu, Steve, A,16294 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Tang, Kurt, G,13847 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Wu, Crystal, W,22672 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Rowe, Alberto, W,26973 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Liu, Shannon, D,11250 | 7116.25 | 0.00 | 3399.99 | 0.00 | 3716.26 |
Generated 2025-12-23 09:11:14.024 UTC