[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1248 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Chandra, Summer, D,24880 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suarez, Sheila,28884 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| Barnes, Vanessa,13810 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Kovar, Kristina, R,26910 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Young, Evan,12739 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Evans, Lucas, J,11556 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Subram, Mayra, C,28446 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Zhu, Stacey, E,22636 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Zhao, Omar,27927 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Goel, Kathryn,12740 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Deng, Lindsay, K,29447 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Wright, Elijah, I,25577 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sun, Brent,25585 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Hu, Candice,27818 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Liang, Clayton, E,14958 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Hu, Steve, A,16294 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lopez, James, E,20806 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Subram, Cynthia, A,20965 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Suri, Veronica, D,23967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jackson, Lucas, A,25481 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Guo, Clayton, J,22302 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Campbell, Andrea,25689 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Yuan, Arturo,20968 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Yuan, Drew, R,21679 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Yuan, Shawn, P,27762 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Alonso, Larry, B,13586 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Romero, Tabitha, M,22416 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Shan, Kathryn, K,28916 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Richardson, Julia, N,27331 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Yuan, Alison, K,24574 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kennedy, Kelsey, M,23984 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, Edwin,11469 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Serrano, Tanya,23750 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Navarro, Hector,23907 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Rubio, Clinton, A,25612 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Lal, Tasha, A,28408 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Navarro, Arthur,16198 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Li, Heather, C,12803 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| Deng, Ricardo,21111 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Jai, Darrell, T,20951 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Rana, Cynthia, L,28397 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Patel, Bruce,27165 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Suri, Carla,25547 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Moyer, Philip, M,16386 | 129.95 | 0.00 | 0.00 | 0.00 | 129.95 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Deng, Leonard,27821 | 2428.05 | 0.00 | 0.00 | 2428.05 | 0.00 |
| Gutierrez, Casey,12519 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Vazquez, Stacy,22559 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Rowe, Alberto, W,26973 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Li, Caleb,22640 | 1149.47 | 0.00 | 0.00 | 1149.47 | 0.00 |
| Serrano, Daisy, P,24187 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Alvarez, Daisy, P,22819 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Xu, Jorge, A,14955 | 103.97 | 0.00 | 0.00 | 0.00 | 103.97 |
| Mehta, Cynthia,14175 | 108.96 | 0.00 | 0.00 | 0.00 | 108.96 |
| Bhat, Drew,14820 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Lin, Cara,29411 | 1223.84 | 0.00 | 0.00 | 1223.84 | 0.00 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Travers, Micheal,26397 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lal, Cassie,12626 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Nelson, Haley,27185 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Li, Leah,12871 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Lal, Nichole, P,25753 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Raman, Francisco, M,24020 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zheng, Trisha,22437 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Rai, Kara, D,26970 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Rachael, M,23636 | 2479.94 | 0.00 | 0.00 | 2479.94 | 0.00 |
| Blanco, Gina,28918 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Xu, Terrence, L,23743 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Morgan, Angel, G,24835 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Fernandez, Harold, C,29359 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Becker, Karla, M,12730 | 64.90 | 0.00 | 0.00 | 0.00 | 64.90 |
| Hernandez, Mason, C,27782 | 47.97 | 0.00 | 0.00 | 47.97 | 0.00 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Guo, Christy, R,23639 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 607.96 | 0.00 |
| Sun, Omar, D,25783 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Vance, Joe, L,28877 | 12.98 | 0.00 | 0.00 | 12.98 | 0.00 |
| Xu, Mario,26411 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Gonzalez, Ruben, A,22468 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Subram, Gerald,21517 | 3172.97 | 0.00 | 0.00 | 782.99 | 2389.98 |
| Garcia, Kristopher, M,19070 | 4748.33 | 0.00 | 0.00 | 2443.35 | 2304.98 |
| Ms., Song, Lolan,19073 | 4760.32 | 0.00 | 0.00 | 2443.35 | 2316.97 |
| Jiménez, Javier, M,22687 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Ruiz, Jaime, J,25609 | 565.47 | 0.00 | 0.00 | 565.47 | 0.00 |
| Russell, Jason, A,27949 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Suri, Ebony, A,22808 | 2478.34 | 0.00 | 0.00 | 2478.34 | 0.00 |
| Lin, Curtis, N,21858 | 2492.32 | 0.00 | 0.00 | 2492.32 | 0.00 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Romero, Melinda,12260 | 241.76 | 0.00 | 0.00 | 182.78 | 58.98 |
| Cook, Carlos, R,26955 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Suarez, Max, A,14809 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| Schmidt, Mayra,17884 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Nath, Katrina, R,11497 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Ruiz, Janet, M,22818 | 56.96 | 0.00 | 0.00 | 56.96 | 0.00 |
| Madan, Troy,25467 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Raji, Colin, A,25801 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Brooks, Savannah, R,24558 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Raje, Kelsey, W,12227 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Alonso, Felicia, A,26842 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Navarro, Robin, J,28696 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Xie, Tommy, J,29425 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Hu, Louis,16187 | 34.92 | 0.00 | 0.00 | 0.00 | 34.92 |
| Blanco, Jaime,22528 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Muñoz, Armando, E,19906 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perry, Hailey, G,20721 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Munoz, Roberto,17628 | 106.24 | 0.00 | 0.00 | 7.28 | 98.96 |
| Patel, Rebekah, R,22396 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Fernandez, Heidi, L,22798 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gill, Kristi, A,27171 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Zeng, Alan, M,22321 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Henderson, Alexandria, R,11555 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
Generated 2024-11-10 15:30:40.765 UTC