[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1750 > < TAKE 250 >
140 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Hu, Vincent, F,28372 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Alonso, Albert, M,17645 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
| Washington, Kelly, M,28748 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Fernandez, Roy, S,15444 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Luo, Katrina, J,18147 | 6930.59 | 0.00 | 0.00 | 2181.56 | 4749.03 |
| Chen, Alejandro,14947 | 6658.58 | 0.00 | 3578.27 | 0.00 | 3080.31 |
| Reed, Cole,12603 | 117.45 | 0.00 | 0.00 | 0.00 | 117.45 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Dominguez, Teresa, C,20963 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 2181.56 | 928.49 | 0.00 |
| Romero, Teresa, A,26834 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gonzalez, Allen,25572 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Munoz, Stacy,12310 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Patel, Stefanie,27967 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Zhou, Rosa, D,25573 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Pal, Maurice,26929 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Goel, Kathryn,12740 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Arun, Evelyn,27842 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Fernandez, Jillian, K,12599 | 5649.21 | 0.00 | 0.00 | 2071.42 | 3577.79 |
| Rai, Colin, W,24573 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Reed, Rachel, E,12644 | 6838.12 | 0.00 | 0.00 | 2049.10 | 4789.02 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Luo, Alejandro, K,12316 | 6799.45 | 0.00 | 0.00 | 4455.49 | 2343.96 |
| Deng, Lindsay, K,29447 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sanz, Mallory,14938 | 107.97 | 0.00 | 0.00 | 0.00 | 107.97 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Butler, Kayla, J,25748 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Russell, Aaron,25599 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Gonzalez, Geoffrey,11603 | 6767.14 | 0.00 | 2049.10 | 0.00 | 4718.04 |
| Nath, Katrina, R,11497 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Weber, Stanley, E,12311 | 116.43 | 0.00 | 0.00 | 0.00 | 116.43 |
| Deng, Leonard,27821 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Alvarez, Casey, A,28557 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| McDonald, George,11394 | 8161.97 | 0.00 | 3399.99 | 2342.92 | 2419.06 |
| Rogers, Bryan,26890 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Navarro, Joy,16410 | 3242.77 | 0.00 | 0.00 | 2443.35 | 799.42 |
| Li, Suzanne,21508 | 3152.95 | 0.00 | 0.00 | 782.99 | 2369.96 |
| Raje, Roger, E,11596 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Nath, Tonya,24847 | 2552.82 | 0.00 | 0.00 | 0.00 | 2552.82 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Perez, Meagan, R,21101 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Deng, Dustin, F,11422 | 7075.27 | 0.00 | 3399.99 | 2334.98 | 1340.30 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Baker, Mackenzie,16563 | 62.95 | 0.00 | 0.00 | 13.98 | 48.97 |
| Suarez, Clinton,22657 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lin, Cara,29411 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Alvarez, Danny,13820 | 5908.26 | 0.00 | 3578.27 | 0.00 | 2329.99 |
| Sanz, Frank, T,20851 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Suri, Summer,26219 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Goel, Sharon, M,19430 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Patel, Barry, J,26218 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Subram, Mayra, C,28446 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Subram, Dominique, S,15620 | 5959.72 | 0.00 | 3578.27 | 0.00 | 2381.45 |
| Malhotra, Meagan, L,27827 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Sanz, Jay,28503 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Prasad, Virginia,17933 | 3103.31 | 0.00 | 0.00 | 2443.35 | 659.96 |
| Suarez, Shannon, R,12633 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Kapoor, Marco,19512 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Blanco, Gina,28918 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Krista,28913 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Carlson, Tyrone, S,22662 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cai, Lacey, L,12733 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Suri, Martin,16589 | 7343.69 | 0.00 | 0.00 | 2443.35 | 4900.34 |
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Shen, Carl, L,19190 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Moreno, Carrie, W,27151 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Black, Nina, L,17968 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Dominguez, Deanna,23779 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Stewart, Natalie, F,17710 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Xu, Marshall, K,25747 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Brown, Richard, M,29357 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| _SUM | 3388349.72 | 53209.72 | 561750.64 | 829400.81 | 1943988.55 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Romero, Jerome,11337 | 8162.00 | 0.00 | 3374.99 | 2388.96 | 2398.05 |
| Pal, Mohamed,20550 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Torres, Victor,18030 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Jimenez, Jessie,11344 | 8119.81 | 0.00 | 3399.99 | 2297.28 | 2422.54 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Gutierrez, Daisy,21541 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Lal, Wayne, C,16829 | 7185.37 | 0.00 | 0.00 | 2443.35 | 4742.02 |
| Butler, Natalie,26401 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xie, Franklin, A,17747 | 2743.53 | 0.00 | 0.00 | 2181.56 | 561.97 |
| Dominguez, Julio, E,17094 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Walker, Madison,17105 | 83.44 | 0.00 | 0.00 | 39.98 | 43.46 |
| Chander, Christy, E,21548 | 36.93 | 0.00 | 0.00 | 0.00 | 36.93 |
| Sun, Brent,25585 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Srini, Ebony, A,17959 | 2748.83 | 0.00 | 0.00 | 2181.56 | 567.27 |
| Chande, Priscilla,29358 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Martin, Alexander, K,16402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Watson, Bryce,27799 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Vance, Kaitlin,29383 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Lopez, Ronald,17855 | 189.96 | 0.00 | 0.00 | 0.00 | 189.96 |
| Torres, Deb,11550 | 5241.43 | 0.00 | 2049.10 | 777.34 | 2414.99 |
| Subram, Cynthia, A,20965 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Xu, Laura, D,16287 | 4538.84 | 0.00 | 0.00 | 2181.56 | 2357.28 |
| Guo, Dawn, R,25603 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Rana, Andre,27904 | 156.76 | 0.00 | 0.00 | 0.00 | 156.76 |
| Navarro, Robin, J,28696 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 0.00 | 4752.52 |
| Gill, Kristi, A,27171 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Shan, Karla,19493 | 3515.37 | 0.00 | 0.00 | 3515.37 | 0.00 |
| She, Gilbert,19505 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Stewart, Megan, L,11413 | 7189.75 | 0.00 | 3399.99 | 0.00 | 3789.76 |
| Raman, Cynthia, P,27786 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Rivera, Bryan,18160 | 6914.59 | 0.00 | 0.00 | 2181.56 | 4733.03 |
| Raji, Lindsay, E,22669 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Chen, Dennis, M,17627 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Sun, Heather,28729 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Suri, Joe,21028 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| James, Gabriella, S,22594 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Ruiz, Jill, P,14423 | 141.91 | 0.00 | 0.00 | 0.00 | 141.91 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Black, Roger, J,28416 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Lu, Erica,27009 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Martin, Jerome, D,20170 | 3177.44 | 0.00 | 699.10 | 0.00 | 2478.34 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Madan, Frederick,16550 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Gutierrez, Robin,21104 | 2566.95 | 0.00 | 0.00 | 782.99 | 1783.96 |
| Fernandez, Harold, C,29359 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Walker, Sarah, R,13814 | 230.04 | 0.00 | 0.00 | 0.00 | 230.04 |
| Kovar, Shane, L,12294 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hu, Lisa, L,21118 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Bell, Sebastian, D,27785 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Subram, Ebony, K,26216 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Smith, Hunter, L,21507 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Goel, Gregory,28712 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Gao, Ernest,27828 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Muñoz, Armando, E,19906 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
Generated 2025-12-17 12:28:26.658 UTC