[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Alisha,26848 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Jenkins, Adam, M,18633 | 2793.50 | 0.00 | 0.00 | 2181.56 | 611.94 |
| Chandra, Ronald, H,20801 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ward, Marcus, L,19511 | 3524.36 | 0.00 | 0.00 | 1000.44 | 2523.92 |
| Deng, Kelli,22794 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Luo, Katrina, J,18147 | 6930.59 | 0.00 | 0.00 | 2181.56 | 4749.03 |
| Sai, Tabitha,25741 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Rai, Warren, F,21534 | 1622.45 | 0.00 | 0.00 | 1622.45 | 0.00 |
| Gomez, Joe, E,16574 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Lee, Jacob,13551 | 5622.92 | 0.00 | 0.00 | 2049.10 | 3573.82 |
| Moreno, Reginald, H,16050 | 76.94 | 0.00 | 0.00 | 0.00 | 76.94 |
| Moreno, Paula, W,13554 | 5641.25 | 0.00 | 0.00 | 2071.42 | 3569.83 |
| Gutierrez, Marie, F,29431 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Liu, Stacey, A,13557 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Sanz, Joanna, L,25732 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Perez, Regina, S,19031 | 7226.38 | 0.00 | 0.00 | 2443.35 | 4783.03 |
| Blanco, Mathew, B,12595 | 40.27 | 0.00 | 0.00 | 0.00 | 40.27 |
| Wang, Cara,21023 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Romero, Nelson,25728 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Torres, Tanya, L,23986 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Wu, Ramon, M,27955 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Holt, Brittney,19523 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Prasad, Cindy, C,26914 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Schmidt, Dana, S,25641 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Gill, Paula, W,28524 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Russell, Jason, A,27949 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
| Gao, Autumn, W,24085 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Luo, Dale, M,22613 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Martinez, Bryant,19471 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Lin, Randy,14540 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| She, Wayne,23607 | 2451.30 | 0.00 | 0.00 | 2451.30 | 0.00 |
| Zheng, Franklin,21044 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Lal, Lacey, L,23751 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Yuan, Katie,19459 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Beck, Christine,20714 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Rogers, Melissa, J,28415 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Torres, Renee, L,19510 | 3451.74 | 0.00 | 0.00 | 1000.44 | 2451.30 |
| Martinez, Carla,24852 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Reed, Taylor,23983 | 1195.47 | 0.00 | 0.00 | 0.00 | 1195.47 |
| Xie, Carly, R,13253 | 6774.45 | 0.00 | 0.00 | 2071.42 | 4703.03 |
| Carlson, Diane, W,21074 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Blanco, Theresa,26824 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Carlson, Felicia,19502 | 3565.36 | 0.00 | 0.00 | 1000.44 | 2564.92 |
| Lu, Clayton, L,23613 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Lopez, Morgan, F,19466 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Gutierrez, Robin,21104 | 2566.95 | 0.00 | 0.00 | 782.99 | 1783.96 |
| Yang, Jessie, E,20053 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Raman, George, M,26359 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Shan, Karla,19493 | 3515.37 | 0.00 | 0.00 | 3515.37 | 0.00 |
| Wagner, Deb, R,24030 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Wu, Roger,22630 | 1164.47 | 0.00 | 0.00 | 1164.47 | 0.00 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Ms., Smith, Samantha,29407 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Suarez, Victor, N,24071 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Wang, Christy,19498 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Raman, Andre, D,24079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Ruben, J,25304 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Arun, Evelyn,27842 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Raji, April, L,14981 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Rai, Alicia, M,28914 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Brooks, Haley, S,17193 | 134.96 | 0.00 | 0.00 | 0.00 | 134.96 |
| Rodriguez, Chelsea,12525 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Subram, Bobby, J,29373 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Li, Susan,27839 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Ruiz, Janet, M,22818 | 56.96 | 0.00 | 0.00 | 56.96 | 0.00 |
| Zeng, Martha, J,17844 | 196.26 | 0.00 | 0.00 | 0.00 | 196.26 |
| Wang, Franklin, S,29386 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Diaz, Julio, J,24094 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Scott, Mackenzie, L,25676 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Carlson, Dana, H,14863 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ortega, Leslie,24851 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Suarez, Kristine,16282 | 64.25 | 0.00 | 0.00 | 0.00 | 64.25 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Davis, Zachary, L,16579 | 97.95 | 0.00 | 0.00 | 0.00 | 97.95 |
| Prasad, Jillian,12860 | 4464.09 | 0.00 | 0.00 | 2049.10 | 2414.99 |
| Wu, Crystal, W,22672 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Hu, Jake, L,24576 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Lin, Candice, K,19506 | 3480.38 | 0.00 | 0.00 | 1000.44 | 2479.94 |
| Torres, Cheryl, T,25727 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Turner, Charles,24188 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Shan, Russell,19500 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Nara, Jaime, D,13262 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Foster, Mya, M,23230 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Castro, Jacquelyn,21093 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| He, Jenny, C,24100 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Ramos, Janet, B,20596 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Navarro, Gary, E,13561 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Allen, Miguel, C,11385 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Kapoor, Jillian, R,15701 | 78.86 | 0.00 | 0.00 | 0.00 | 78.86 |
| Coleman, Jessica,13553 | 5603.24 | 0.00 | 0.00 | 2071.42 | 3531.82 |
| Deng, Corey,28921 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Liang, Sandra, J,20949 | 154.98 | 0.00 | 0.00 | 0.00 | 154.98 |
| Schmidt, Michele, M,21545 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Goel, Willie, T,22656 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Fernandez, Kari,13788 | 200.81 | 0.00 | 0.00 | 0.00 | 200.81 |
| Rogers, Christina, F,21668 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Nara, April, E,25721 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Madan, Carolyn,26222 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Goel, Shawn, L,19058 | 4524.48 | 0.00 | 0.00 | 2181.56 | 2342.92 |
| Subram, Cynthia, A,20965 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Nath, Colleen,24051 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Ruiz, Jaime, J,25609 | 565.47 | 0.00 | 0.00 | 565.47 | 0.00 |
| Jackson, Lucas, A,25481 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Xie, Edwin, E,28879 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Rana, Roy, M,22667 | 1170.48 | 0.00 | 0.00 | 1170.48 | 0.00 |
| Gutierrez, Wendy,12610 | 101.95 | 0.00 | 0.00 | 0.00 | 101.95 |
| Suri, Clifford,19369 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Serrano, Theodore,22631 | 1149.47 | 0.00 | 0.00 | 1149.47 | 0.00 |
| Barnes, Alexis, J,23935 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Larry, D,28694 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Martin, Teresa, D,22588 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Watson, Bryce,27799 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Shan, Tommy, H,22614 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 0.00 | 325.83 |
| Raji, Lindsay, E,22669 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Sharma, Grant, R,23966 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Lin, Curtis, N,21858 | 2492.32 | 0.00 | 0.00 | 2492.32 | 0.00 |
| Yuan, Drew, R,21679 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Zeng, Sandra,25608 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Gomez, Jésus,29401 | 1223.84 | 0.00 | 0.00 | 1223.84 | 0.00 |
| Wu, Susan, L,16564 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
Generated 2025-12-21 08:23:44.593 UTC