[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hernandez, Tyrone, C,12271 | 5683.18 | 0.00 | 0.00 | 3340.26 | 2342.92 |
| Allen, Miguel, C,11385 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ross, Gabriel, K,16314 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Zhu, Karen, R,18012 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Gill, Lori, A,22510 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Kumar, Peter,26915 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Gill, Marvin, M,17821 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Campbell, Katherine, P,28448 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Zhang, Alvin,19082 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Roberts, Gabriella, J,16553 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Brown, Richard, M,29357 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Dominguez, Victor, K,14784 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Ramos, Kari, D,24702 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Brooks, Christina, W,22496 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Alonso, Hector, L,12134 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Lal, Wayne, C,16829 | 7185.37 | 0.00 | 0.00 | 2443.35 | 4742.02 |
| Goel, Katrina,21682 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Srini, Cesar,11563 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Lin, Marshall,16822 | 7176.38 | 0.00 | 0.00 | 2443.35 | 4733.03 |
| Tang, Lindsey, C,25308 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Navarro, Wendy, C,20881 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Suri, Ebony, A,22808 | 2478.34 | 0.00 | 0.00 | 2478.34 | 0.00 |
| Lu, Erica,27009 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| James, Gabriella, S,22594 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Subram, Cynthia, A,20965 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Kapoor, Jillian, R,15701 | 78.86 | 0.00 | 0.00 | 0.00 | 78.86 |
| Kapoor, Heidi, D,17937 | 3068.82 | 0.00 | 0.00 | 2443.35 | 625.47 |
| Jackson, Lucas, A,25481 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Arthur, Carmen, M,12567 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Xie, Franklin, A,17747 | 2743.53 | 0.00 | 0.00 | 2181.56 | 561.97 |
| Baker, Mackenzie,16563 | 62.95 | 0.00 | 0.00 | 0.00 | 62.95 |
| Malhotra, Johnathan,17723 | 83.94 | 0.00 | 0.00 | 0.00 | 83.94 |
| Price, Brittany,12492 | 5166.41 | 0.00 | 0.00 | 2049.10 | 3117.31 |
| Barnes, Alexis, J,23935 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wu, Roger,22630 | 1164.47 | 0.00 | 0.00 | 1164.47 | 0.00 |
| Romero, Theodore,23747 | 1142.42 | 0.00 | 0.00 | 0.00 | 1142.42 |
| Martin, Teresa, D,22588 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Ortega, Jésus, L,16542 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Carlson, Desiree, V,14864 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Guo, Clayton, J,22302 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Navarro, Robin, J,28696 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Rodriguez, Manuel, A,24697 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Ortega, Leslie,24851 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Deng, Drew, E,17882 | 32.27 | 0.00 | 0.00 | 32.27 | 0.00 |
| Hu, Jake, L,24576 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Blanco, Jaime,22528 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Turner, Charles,24188 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Brooks, Savannah, R,24558 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Yuan, Drew, R,21679 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Gutierrez, Eddie, R,28370 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Lopez, Marie,16192 | 101.45 | 0.00 | 0.00 | 29.48 | 71.97 |
| Liang, Mandy,28371 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Carlson, Gary, R,24115 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Shan, Kathryn, K,28916 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Foster, Mary,24112 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Nath, Nichole, K,12392 | 75.47 | 0.00 | 0.00 | 25.48 | 49.99 |
| She, Clayton,13785 | 121.83 | 0.00 | 0.00 | 0.00 | 121.83 |
| Rivera, Dalton, E,28366 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Ruiz, Janet, M,22818 | 56.96 | 0.00 | 0.00 | 56.96 | 0.00 |
| Jai, Darrell, T,20951 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Thomas, Ryan,22532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Julio, J,24094 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Alonso, Felicia, A,26842 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 0.00 | 325.83 |
| Nath, Colleen,24051 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Chande, Lacey, A,24555 | 58.95 | 0.00 | 0.00 | 0.00 | 58.95 |
| Rana, Lydia,29395 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Xie, Edwin, E,28879 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Richardson, Julia, N,27331 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Johnsen, Jerome,28367 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Zhang, Candice, J,23777 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Ma, Stacey,21840 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Torres, Julio,22460 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Nason, Kirk, J,12874 | 5638.54 | 0.00 | 0.00 | 2071.42 | 3567.12 |
| Suri, Regina,27800 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Alvarez, Lance, J,16190 | 79.25 | 0.00 | 0.00 | 0.00 | 79.25 |
| Raman, Bruce,20886 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Robinson, Nicole,28730 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Schmidt, Meredith,25499 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sanz, Juan, R,14983 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Luo, Alvin,23635 | 2452.34 | 0.00 | 0.00 | 2452.34 | 0.00 |
| Arun, Henry, L,27177 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Lopez, Jonathan, D,15103 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Moyer, Philip, M,16386 | 129.95 | 0.00 | 0.00 | 0.00 | 129.95 |
| Xie, Tommy, J,29425 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Ruiz, Kendra,25598 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Pal, Cedric,23235 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| She, Donna, D,19346 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Zhou, Cara,11350 | 38.47 | 0.00 | 0.00 | 38.47 | 0.00 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Kovar, Shane, L,12294 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Gill, Alfredo, M,23629 | 2466.32 | 0.00 | 0.00 | 2466.32 | 0.00 |
| Torres, Rodney, L,22520 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Ye, Darryl,17790 | 3039.31 | 0.00 | 0.00 | 2443.35 | 595.96 |
| Serrano, Tanya,23750 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Alexander, Ana, R,22637 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Long, Miguel,24853 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Pal, Karl, S,19187 | 147.28 | 0.00 | 0.00 | 0.00 | 147.28 |
| Martin, Alexander, K,16402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Liang, Jessie,19513 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Vance, Francisco, A,20972 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Rana, Kristopher, W,22550 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Nara, Damien, W,26877 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Carlson, Ruben, J,25304 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Cox, Cole, M,25315 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Cai, Rosa,22618 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Rai, Alicia, M,28914 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Andersen, Kelli,22602 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Subram, Bobby, J,29373 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Holt, Dale, C,23618 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Gao, Mandy, M,12560 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| She, Kelvin, T,27002 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
Generated 2025-12-22 00:29:40.582 UTC