[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 438 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Garcia, Tammy, A,12293 | 86.76 | 0.00 | 0.00 | 0.00 | 86.76 |
| Nara, Omar, J,13535 | 59.20 | 0.00 | 0.00 | 0.00 | 59.20 |
| Alvarez, Danny,13820 | 5908.26 | 0.00 | 3578.27 | 0.00 | 2329.99 |
| Xie, Carl, R,18136 | 6904.60 | 0.00 | 0.00 | 2181.56 | 4723.04 |
| Chander, Mario,12590 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Rai, Dale, E,21739 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Jimenez, Lawrence, B,21068 | 81.45 | 0.00 | 0.00 | 0.00 | 81.45 |
| Goel, Sharon, M,19430 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Srini, Ronald, E,16467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raman, Joe, G,16511 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Xie, Sheena,18041 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Patterson, Jessica,17182 | 6950.60 | 0.00 | 0.00 | 2181.56 | 4769.04 |
| Martin, Derrick,14191 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Zheng, Lisa, R,13846 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Carlson, Craig, G,17218 | 6907.56 | 0.00 | 0.00 | 2181.56 | 4726.00 |
| Edwards, Edward,14700 | 5904.23 | 0.00 | 3578.27 | 0.00 | 2325.96 |
| Li, Sandra,13679 | 5933.26 | 3578.27 | 0.00 | 0.00 | 2354.99 |
| Gray, Savannah, E,13694 | 105.56 | 0.00 | 0.00 | 0.00 | 105.56 |
| Deng, Chad,22611 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Jenkins, Adam, M,18633 | 2793.50 | 0.00 | 0.00 | 2181.56 | 611.94 |
| Sharma, James, L,21049 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Shan, Sharon, A,24211 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Ross, Gabrielle, J,19253 | 1540.43 | 0.00 | 1000.44 | 0.00 | 539.99 |
| Malhotra, Jay,14159 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Alonso, Jaime,15062 | 6684.59 | 0.00 | 3578.27 | 0.00 | 3106.32 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Ruiz, Jill, P,14423 | 141.91 | 0.00 | 0.00 | 0.00 | 141.91 |
| Thomas, Jose, A,26960 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Anderson, Benjamin,20809 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Zhao, Colleen, L,16407 | 3250.11 | 0.00 | 2443.35 | 0.00 | 806.76 |
| Hernandez, Anne, B,11240 | 7586.23 | 3399.99 | 0.00 | 2369.96 | 1816.28 |
| Ramos, Daisy,14552 | 103.97 | 0.00 | 0.00 | 0.00 | 103.97 |
| Suri, Cynthia,22589 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alvarez, Neil, C,22467 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Lopez, Allen, O,13821 | 5940.54 | 3578.27 | 0.00 | 0.00 | 2362.27 |
| Munoz, Stacy,12310 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Fernandez, Kari,13788 | 200.81 | 0.00 | 0.00 | 0.00 | 200.81 |
| Shen, Jaime,13765 | 7152.09 | 3578.27 | 0.00 | 0.00 | 3573.82 |
| Liu, Eugene,14712 | 6660.59 | 0.00 | 3578.27 | 0.00 | 3082.32 |
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Ramos, Pedro, P,29416 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Hu, Lisa, L,21118 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Lee, Emily,20585 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Dominguez, Jessie, A,25628 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Blanco, Rebekah,18149 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Ms., Slattengren, Dianne, K.,27928 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Raji, Mario,28695 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Griffin, Spencer,13784 | 7138.10 | 3578.27 | 0.00 | 0.00 | 3559.83 |
| Zimmerman, Curtis, T,14702 | 6729.57 | 0.00 | 3578.27 | 777.34 | 2373.96 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hughes, Kayla,14982 | 152.45 | 0.00 | 0.00 | 118.47 | 33.98 |
| Romero, Jerome,11337 | 8162.00 | 3374.99 | 0.00 | 2388.96 | 2398.05 |
| Dominguez, Naomi, B,14720 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Sai, Allen, E,27781 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Ruiz, Theodore,20052 | 3214.03 | 699.10 | 0.00 | 2514.93 | 0.00 |
Generated 2025-11-04 04:44:52.505 UTC