[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 62 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arun, Henry, L,27177 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Lopez, Jonathan, D,15103 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Ruiz, Kendra,25598 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Dominguez, Victor, K,14784 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Perry, Jose, M,12729 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Jackson, Kayla, R,20060 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Ramos, Felicia,11557 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Andersen, Jaclyn,11468 | 6959.82 | 0.00 | 3374.99 | 2319.99 | 1264.84 |
| Nath, Nichole, K,12392 | 75.47 | 0.00 | 0.00 | 25.48 | 49.99 |
| Ruiz, Janet, M,22818 | 56.96 | 0.00 | 0.00 | 56.96 | 0.00 |
| Diaz, Julio, J,24094 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Jimenez, Jessie,11344 | 8119.81 | 0.00 | 3399.99 | 2297.28 | 2422.54 |
| Lopez, Jermaine,11488 | 8090.33 | 0.00 | 3374.99 | 2322.28 | 2393.06 |
| Ortega, Gary,11496 | 7013.79 | 0.00 | 3399.99 | 2398.95 | 1214.85 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 0.00 | 3578.27 | 0.00 | 3593.31 |
| Alexander, Ana, R,22637 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Martin, Alexander, K,16402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Nara, Damien, W,26877 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Cai, Rosa,22618 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ramos, Julio,12551 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Patel, Bruce,27165 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| She, Donna, D,19346 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Raman, Meredith,11381 | 8161.02 | 0.00 | 3399.99 | 2341.97 | 2419.06 |
| Sanchez, Darren,12502 | 110.46 | 0.00 | 0.00 | 60.47 | 49.99 |
| Zheng, Leah, R,12627 | 110.94 | 0.00 | 0.00 | 0.00 | 110.94 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Raje, Julie, H,12214 | 6803.92 | 0.00 | 0.00 | 2049.10 | 4754.82 |
| Jai, Casey, C,22560 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Mrs., West, Alyssa,23219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Latasha, L,22540 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Zhao, Valerie, R,13493 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Andersen, Melvin, D,14770 | 6679.59 | 0.00 | 3578.27 | 0.00 | 3101.32 |
| Jimenez, Renee,14778 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Andersen, Tamara, B,29392 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Romero, Gerald, K,19322 | 1565.43 | 0.00 | 0.00 | 1000.44 | 564.99 |
| Xie, Brad, D,19302 | 1577.39 | 0.00 | 0.00 | 1000.44 | 576.95 |
| Alonso, Arthur, M,19054 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Zhu, Arturo, M,24575 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| She, Warren,21824 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Lopez, Courtney,20839 | 2511.26 | 0.00 | 0.00 | 782.99 | 1728.27 |
| Deng, Ricardo,21111 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Richardson, Ian,11414 | 7191.77 | 0.00 | 3399.99 | 0.00 | 3791.78 |
| Romero, Juan, A,16324 | 3282.81 | 0.00 | 0.00 | 2443.35 | 839.46 |
| Gonzalez, Preston, L,14156 | 229.57 | 0.00 | 0.00 | 0.00 | 229.57 |
| Suri, Carla,25547 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Rubio, Jésus,25616 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gill, Craig, R,29379 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Raje, Andres,20710 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Fernandez, Roy, S,15444 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
Generated 2025-12-22 00:10:23.743 UTC