[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 126 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Jermaine,11488 | 8090.33 | 0.00 | 3374.99 | 2322.28 | 2393.06 |
| Andersen, Tamara, B,29392 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 2071.42 | 4754.04 |
| Liang, Cedric, R,19941 | 3078.06 | 699.10 | 0.00 | 0.00 | 2378.96 |
| Rubio, Victor, S,16193 | 90.47 | 0.00 | 0.00 | 0.00 | 90.47 |
| Goel, Latoya, C,11239 | 7511.55 | 3374.99 | 0.00 | 2353.95 | 1782.61 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Butler, Blake,13583 | 8375.29 | 3578.27 | 0.00 | 0.00 | 4797.02 |
| Brooks, Savannah, R,24558 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Srini, Virginia,20048 | 3142.45 | 699.10 | 0.00 | 0.00 | 2443.35 |
| Zhou, Martha, M,14804 | 138.96 | 0.00 | 0.00 | 0.00 | 138.96 |
| Xie, Mario,13687 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhou, Claudia, M,11247 | 7131.51 | 0.00 | 3374.99 | 2340.23 | 1416.29 |
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Ramos, Teresa,13689 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Chen, Heather, M,29408 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Taylor, Charles,13792 | 7216.08 | 0.00 | 3578.27 | 0.00 | 3637.81 |
| Romero, Teresa, A,26834 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ruiz, Theodore,20052 | 3214.03 | 0.00 | 699.10 | 0.00 | 2514.93 |
| Garcia, Ryan, J,15692 | 8392.30 | 0.00 | 3578.27 | 0.00 | 4814.03 |
| Wright, Logan, M,13783 | 5955.23 | 0.00 | 3578.27 | 0.00 | 2376.96 |
| Anderson, Cameron, L,16595 | 6901.38 | 0.00 | 0.00 | 2181.56 | 4719.82 |
| Miller, Emily, R,11333 | 8163.31 | 0.00 | 3399.99 | 2344.26 | 2419.06 |
| Li, Sandra,13679 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Arun, Heidi, Z,20149 | 3165.42 | 0.00 | 699.10 | 0.00 | 2466.32 |
| Cook, Carlos, R,26955 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Carlson, Arthur, P,11343 | 8221.99 | 0.00 | 3399.99 | 0.00 | 4822.00 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Guo, Roger,13539 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Moreno, Craig, N,14158 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Deng, Dale,28399 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Carlson, Robyn, M,14183 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 |
| Bailey, Xavier,12305 | 4940.39 | 0.00 | 0.00 | 2071.42 | 2868.97 |
| Blanco, Clinton, J,14195 | 8316.29 | 0.00 | 3578.27 | 0.00 | 4738.02 |
| Schmidt, Theresa,21854 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Liang, Marshall, J,25447 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Wood, Riley,14705 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Ruiz, Ricky,20718 | 3283.43 | 0.00 | 0.00 | 782.99 | 2500.44 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Baker, Seth,21520 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Lee, Jacob,13551 | 5622.92 | 0.00 | 0.00 | 2049.10 | 3573.82 |
| Hayes, Riley,14833 | 6679.60 | 0.00 | 3578.27 | 0.00 | 3101.33 |
| Chande, Priscilla,29358 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Ortega, Carrie, L,11353 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Martinez, Jarrod, H,22313 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Vazquez, Lee,14843 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Zhang, Franklin, L,12597 | 53.21 | 0.00 | 0.00 | 0.00 | 53.21 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Alonso, Theodore,24186 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Ma, Stacey,21840 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Xie, Gilbert,14831 | 5912.73 | 0.00 | 3578.27 | 0.00 | 2334.46 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Andersen, Melvin, D,14770 | 6679.59 | 0.00 | 3578.27 | 0.00 | 3101.32 |
| Black, Shawn, A,19499 | 3492.76 | 0.00 | 0.00 | 3492.76 | 0.00 |
| Rubio, Jerome, L,14792 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
Generated 2025-12-22 05:37:41.319 UTC