[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Blanco, Albert, W,13581 | 8374.79 | 3578.27 | 0.00 | 0.00 | 4796.52 |
| Miller, Emily, R,11333 | 8163.31 | 3399.99 | 0.00 | 2344.26 | 2419.06 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Mr., Shimshoni, Daniel,24705 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Subram, Ebony, K,26216 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Mehta, Virginia,13602 | 8376.28 | 3578.27 | 0.00 | 0.00 | 4798.01 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 3578.27 | 0.00 | 0.00 | 3593.31 |
| Jenkins, Caleb,14184 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Gao, Claudia,13690 | 7162.08 | 3578.27 | 0.00 | 0.00 | 3583.81 |
| Bailey, Ariana, J,13691 | 5976.74 | 3578.27 | 0.00 | 0.00 | 2398.47 |
| Sanchez, Emmanuel, F,21856 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Shen, Jaime,13765 | 7152.09 | 3578.27 | 0.00 | 0.00 | 3573.82 |
| Prasad, Virginia,17933 | 3103.31 | 0.00 | 0.00 | 2443.35 | 659.96 |
| Taylor, Joseph, T,12289 | 5645.86 | 0.00 | 0.00 | 2049.10 | 3596.76 |
| Yang, Ryan,28723 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Walker, Sydney, A,19047 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Nara, Shawn, C,13845 | 5917.24 | 3578.27 | 0.00 | 0.00 | 2338.97 |
| Alvarez, Danny,13820 | 5908.26 | 3578.27 | 0.00 | 0.00 | 2329.99 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Raji, Nina, W,29480 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Liu, Eugene,14712 | 6660.59 | 0.00 | 3578.27 | 0.00 | 3082.32 |
| Chen, Jeffery, C,16827 | 7205.36 | 0.00 | 0.00 | 2443.35 | 4762.01 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Rubio, Gary, M,20150 | 3264.02 | 0.00 | 699.10 | 0.00 | 2564.92 |
| Zimmerman, Curtis, T,14702 | 6729.57 | 0.00 | 3578.27 | 777.34 | 2373.96 |
| Gutierrez, Kristy,24138 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Wood, Riley,14705 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 776.33 | 2329.98 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Lopez, Raymond, G,27317 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Romero, Kristine, W,16306 | 29.26 | 0.00 | 0.00 | 21.98 | 7.28 |
| Xie, Gilbert,14831 | 5912.73 | 0.00 | 3578.27 | 0.00 | 2334.46 |
| Madan, Gerald, E,15653 | 5204.06 | 0.00 | 3578.27 | 0.00 | 1625.79 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Nath, Colin, N,11398 | 8114.04 | 0.00 | 3399.99 | 2294.99 | 2419.06 |
| Mitchell, Isaac,14554 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Xu, Brendan, L,14937 | 6652.89 | 0.00 | 3578.27 | 0.00 | 3074.62 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Sun, Heather,28729 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Vazquez, Meghan, W,15047 | 6669.57 | 0.00 | 3578.27 | 0.00 | 3091.30 |
| Chande, Kelsey, K,14846 | 6744.57 | 0.00 | 3578.27 | 0.00 | 3166.30 |
| Mr., Sazanovich, Vadim,14847 | 6725.57 | 0.00 | 3578.27 | 0.00 | 3147.30 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Raji, Tracy,22439 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Wu, Cedric, E,21025 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| McDonald, Harold, J,15051 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Green, Morgan, M,28469 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Moyer, Felicia, C,28880 | 637.96 | 0.00 | 0.00 | 0.00 | 637.96 |
| Collins, Blake,11610 | 6786.44 | 0.00 | 2071.42 | 0.00 | 4715.02 |
| Henderson, Julian, J,15691 | 8341.29 | 0.00 | 3578.27 | 0.00 | 4763.02 |
| Andersen, Brad, S,26992 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Kelly, Richard,17991 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Madan, Dominic, F,21847 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Bell, Sebastian, D,27785 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hernandez, Lori,18186 | 139.44 | 0.00 | 0.00 | 0.00 | 139.44 |
| Ruiz, Audrey,12645 | 6847.76 | 0.00 | 0.00 | 2071.42 | 4776.34 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Andersen, Keith,11612 | 6795.12 | 0.00 | 2049.10 | 0.00 | 4746.02 |
| Griffin, Ashley,24865 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Samant, Mandar,12873 | 5676.24 | 0.00 | 0.00 | 2071.42 | 3604.82 |
| Prasad, Jillian,12860 | 4464.09 | 0.00 | 0.00 | 2049.10 | 2414.99 |
| Ruiz, Marc, D,12545 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Sanchez, Brenda,25656 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Navarro, Lee,25659 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Long, Maria,16036 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Hayes, Marcus, A,15657 | 5251.34 | 0.00 | 3578.27 | 0.00 | 1673.07 |
| Patterson, Margaret, J,13507 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Gao, Jessie,20564 | 3059.08 | 0.00 | 699.10 | 0.00 | 2359.98 |
| Cai, Colleen, J,15088 | 5896.19 | 0.00 | 3578.27 | 0.00 | 2317.92 |
| Carlson, Gloria, P,15632 | 5245.06 | 0.00 | 3578.27 | 889.45 | 777.34 |
| Gutierrez, Jimmy, M,11494 | 6973.81 | 0.00 | 3399.99 | 2329.98 | 1243.84 |
| Kapoor, Johnathan,20576 | 3147.96 | 0.00 | 782.99 | 0.00 | 2364.97 |
| Lin, Erica, E,16033 | 3743.39 | 0.00 | 2181.56 | 0.00 | 1561.83 |
| Guo, Kelvin, H,17705 | 37.26 | 0.00 | 0.00 | 29.98 | 7.28 |
| Parker, Eric, H,27130 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hu, Vincent, F,28372 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Gomez, Larry, S,25778 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Gonzales, Jessica, A,15610 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Chander, Mario,12590 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Liu, Jorge, J,20592 | 3113.22 | 0.00 | 782.99 | 0.00 | 2330.23 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Raman, Joel,16317 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 782.99 | 0.00 | 2638.94 |
| Navarro, Joy,16410 | 3242.77 | 0.00 | 2443.35 | 0.00 | 799.42 |
| Mehta, Douglas,19258 | 1574.42 | 0.00 | 1000.44 | 0.00 | 573.98 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Liu, Jamie, J,19301 | 1590.42 | 0.00 | 1000.44 | 0.00 | 589.98 |
| Guo, Wesley,16470 | 3021.04 | 0.00 | 2181.56 | 0.00 | 839.48 |
| Munoz, Kristine,16446 | 3093.03 | 0.00 | 2181.56 | 0.00 | 911.47 |
| Kapoor, Brenda, C,20834 | 2566.95 | 0.00 | 782.99 | 1783.96 | 0.00 |
| Raji, Raul, P,21135 | 103.95 | 0.00 | 0.00 | 0.00 | 103.95 |
| Jai, Damien,14806 | 242.94 | 0.00 | 0.00 | 0.00 | 242.94 |
| Subram, Cesar, L,11475 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Henderson, Marissa,13816 | 260.83 | 0.00 | 0.00 | 0.00 | 260.83 |
| Ruiz, Derrick, C,12634 | 6787.76 | 0.00 | 0.00 | 4490.48 | 2297.28 |
| Edwards, Julia, M,16200 | 96.95 | 0.00 | 0.00 | 39.98 | 56.97 |
| Guo, Roger,13539 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Raman, Martin,17709 | 78.95 | 0.00 | 0.00 | 48.97 | 29.98 |
| Baker, Seth,21520 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Yang, Jackson,22570 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Gutierrez, Craig,19049 | 4838.30 | 0.00 | 0.00 | 2443.35 | 2394.95 |
| Romero, Melinda,12260 | 241.76 | 0.00 | 0.00 | 182.78 | 58.98 |
| Chen, Heather, M,29408 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Yuan, Kristin, C,24114 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 782.99 | 1764.96 | 0.00 |
| Garcia, Emmanuel, T,12263 | 6829.38 | 0.00 | 2071.42 | 0.00 | 4757.96 |
| Madan, Frederick,16550 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 3295.26 | 2329.99 |
| Sun, Vincent, F,16585 | 7192.39 | 0.00 | 0.00 | 2443.35 | 4749.04 |
| Vance, Veronica, G,16575 | 6994.57 | 0.00 | 0.00 | 2181.56 | 4813.01 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2826.44 | 2342.92 |
| Ortega, Beth, A,12277 | 5666.52 | 0.00 | 0.00 | 3309.24 | 2357.28 |
| Liu, Vincent,20848 | 2558.46 | 0.00 | 0.00 | 2558.46 | 0.00 |
| Dominguez, Ruben,16573 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Gao, Lacey, C,16531 | 3291.80 | 0.00 | 0.00 | 2443.35 | 848.45 |
Generated 2025-11-02 00:45:33.838 UTC