[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Carlson, Robyn, M,14183 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Zeng, Randy, A,11341 | 8192.00 | 0.00 | 3399.99 | 2338.97 | 2453.04 |
| Munoz, Daisy,15081 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Wilson, Jacob, H,15078 | 6675.60 | 0.00 | 3578.27 | 0.00 | 3097.33 |
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Rubio, Gary, M,20150 | 3264.02 | 0.00 | 699.10 | 0.00 | 2564.92 |
| Rodriguez, Gerald,12216 | 6955.41 | 0.00 | 0.00 | 2071.42 | 4883.99 |
| Wood, Riley,14705 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| He, Rosa, J,15638 | 5162.37 | 0.00 | 3578.27 | 0.00 | 1584.10 |
| Gonzalez, Geoffrey,11603 | 6767.14 | 0.00 | 2049.10 | 2319.99 | 2398.05 |
| Weadock, Kelly, J,20909 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ruiz, Theodore,20052 | 3214.03 | 699.10 | 0.00 | 2514.93 | 0.00 |
| Navarro, Lawrence,27939 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Vance, Gerald, M,27841 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Gill, Randall, A,18165 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 94.97 | 68.97 |
| Hu, Curtis, G,27880 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Ashe, Francisco, W,12335 | 6912.60 | 0.00 | 0.00 | 6912.60 | 0.00 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Xie, Katrina, M,26897 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Xie, Calvin, A,24858 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shan, Russell,19500 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Hernandez, Lori,18186 | 139.44 | 0.00 | 0.00 | 0.00 | 139.44 |
| Gao, Ernest,27828 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Xu, Shawn,19328 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 42.97 | 14.98 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
Generated 2025-11-06 19:36:20.220 UTC