[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 875 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Sun, Autumn, A,22564 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Diaz, Philip, J,12855 | 4414.34 | 0.00 | 0.00 | 2071.42 | 2342.92 |
| Sara, Henry, L,20892 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Zeng, Darryl, C,20929 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Fernandez, Dominique,12839 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Moreno, Reginald, H,16050 | 76.94 | 0.00 | 0.00 | 39.98 | 36.96 |
| Zheng, Franklin,21044 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Raman, Bruce,20886 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Gutierrez, Marie, F,29431 | 1249.84 | 0.00 | 0.00 | 1249.84 | 0.00 |
| Patel, Kristina,17990 | 2778.52 | 0.00 | 0.00 | 2181.56 | 596.96 |
| Pal, Rafael, J,17715 | 2831.53 | 0.00 | 0.00 | 2831.53 | 0.00 |
| Malhotra, Johnathan,17723 | 83.94 | 0.00 | 0.00 | 64.97 | 18.97 |
| He, Alisha, R,18026 | 2988.32 | 0.00 | 0.00 | 2181.56 | 806.76 |
| Andersen, Leonard,17772 | 2846.00 | 0.00 | 0.00 | 2181.56 | 664.44 |
| Martin, Darren,22695 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Hernandez, Francis,21103 | 2506.95 | 0.00 | 0.00 | 2506.95 | 0.00 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Sai, Jermaine, G,14934 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Torres, Renee, L,19510 | 3451.74 | 0.00 | 0.00 | 1000.44 | 2451.30 |
| Navarro, Robin, J,28696 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Romero, Neil,28424 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Suri, Terrance, C,21046 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Hu, Louis,16187 | 34.92 | 0.00 | 0.00 | 0.00 | 34.92 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rana, Kristopher, W,22550 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Blanco, Jaime,22528 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Subram, Jermaine,28731 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Muñoz, Armando, E,19906 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| Zhao, Valerie, R,13493 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Perry, Hailey, G,20721 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gill, Lori, A,22510 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Sara, Cory, A,21105 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Guo, Kelvin, H,17705 | 37.26 | 0.00 | 0.00 | 29.98 | 7.28 |
| Brown, Richard, M,29357 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Zheng, Jessie, W,18028 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Tang, Lindsey, C,25308 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Malhotra, Meagan, L,27827 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Gonzales, Jessica, A,15610 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Butler, Kayla, J,25748 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Raman, Rebekah, E,22454 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Stone, Stephanie, S,19060 | 29.93 | 0.00 | 0.00 | 29.93 | 0.00 |
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Romero, Alberto,11586 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Xu, Marshall, K,25747 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Xu, Melvin, A,11474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Xie, Franklin, A,17747 | 2743.53 | 0.00 | 0.00 | 2181.56 | 561.97 |
| Gray, Allison, D,20571 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Thompson, Benjamin,19435 | 3457.77 | 0.00 | 0.00 | 3457.77 | 0.00 |
| Vazquez, Carrie,29419 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Bell, Haley, A,29437 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Wagner, Clayton, L,20922 | 3226.34 | 0.00 | 0.00 | 782.99 | 2443.35 |
| Carlson, Desiree, V,14864 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gutierrez, Audrey,17829 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| Rodriguez, Manuel, A,24697 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Sanz, Mallory,14938 | 107.97 | 0.00 | 0.00 | 78.98 | 28.99 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Black, Nicolas,23945 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| She, Todd,23442 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| He, Wesley, I,17849 | 3025.53 | 0.00 | 0.00 | 2181.56 | 843.97 |
| Williams, Emma, K,16325 | 171.27 | 0.00 | 0.00 | 0.00 | 171.27 |
| Deng, Brendan,25726 | 663.44 | 0.00 | 0.00 | 663.44 | 0.00 |
| Ruiz, Derrick, C,12634 | 6787.76 | 0.00 | 0.00 | 4490.48 | 2297.28 |
| Garcia, Tammy, A,12293 | 86.76 | 0.00 | 0.00 | 0.00 | 86.76 |
| Moreno, Lee,25632 | 53.98 | 0.00 | 0.00 | 53.98 | 0.00 |
| Perez, Jack,19455 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Liang, Mandy,28371 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sai, Stanley,13675 | 215.23 | 0.00 | 0.00 | 0.00 | 215.23 |
| Nath, Leonard, L,12637 | 6845.12 | 0.00 | 0.00 | 2049.10 | 4796.02 |
| Davis, Edward,28896 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Prasad, Cynthia, L,14808 | 164.20 | 0.00 | 0.00 | 0.00 | 164.20 |
| Patel, Rebekah, R,22396 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Vance, Gerald, M,27841 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Shan, Lindsay,27186 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Gill, Kristi, A,27171 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Rodriguez, Cory,25739 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Rana, Cesar, L,19044 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Zeng, Alan, M,22321 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Gutierrez, Jésus, E,16437 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Anand, Tonya, A,27141 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Arun, Virginia,25655 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Hayes, Seth, C,17757 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Wang, Kyle,20599 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Xie, Katrina, M,26897 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 94.97 | 68.97 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Madan, Ross, C,27929 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Parker, Haley,14694 | 156.94 | 0.00 | 0.00 | 78.98 | 77.96 |
| Sanchez, Brenda,25656 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 0.00 | 62.76 |
| Sanz, Joanna, L,25732 | 638.95 | 0.00 | 0.00 | 638.95 | 0.00 |
| Gill, Marvin, M,17821 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Browning, Casey,16449 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Anand, Dustin,14535 | 123.47 | 0.00 | 0.00 | 123.47 | 0.00 |
| Shan, Cedric, H,23775 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Alvarez, Theodore,25690 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Carter, Miguel,13776 | 70.57 | 0.00 | 0.00 | 70.57 | 0.00 |
| Gomez, Theodore,13503 | 101.25 | 0.00 | 0.00 | 0.00 | 101.25 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Yuan, Kelvin, L,25692 | 66.97 | 0.00 | 0.00 | 66.97 | 0.00 |
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Ortega, Walter,28377 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Lal, Lacey, L,23751 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Baker, Katherine,19334 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Fernandez, Meagan, C,19448 | 3543.88 | 0.00 | 0.00 | 3543.88 | 0.00 |
| Ma, Damien,15612 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Chander, Warren, A,17965 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Chapman, Bob, W,21134 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sharma, Nichole, M,14692 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
| Zhou, Damien,25776 | 2514.61 | 0.00 | 0.00 | 0.00 | 2514.61 |
| Deng, Yolanda,28427 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Raje, Kate,17974 | 2791.46 | 0.00 | 0.00 | 2181.56 | 609.90 |
| Kumar, Carl,12743 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2024-11-10 11:38:19.787 UTC