[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 1250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| She, Raul,19497 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Henderson, Julian, J,15691 | 8341.29 | 0.00 | 3578.27 | 0.00 | 4763.02 |
| Martin, Sabrina, D,25578 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Blanco, Jessie, R,23608 | 2510.94 | 0.00 | 0.00 | 2510.94 | 0.00 |
| Thompson, Nathan, T,25523 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Carlson, Lee, S,21079 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Townsend, Michelle, P,12864 | 86.24 | 0.00 | 0.00 | 36.27 | 49.97 |
| Garcia, Abigail,14531 | 190.54 | 0.00 | 0.00 | 118.96 | 71.58 |
| Zhao, Eugene,12328 | 6792.11 | 0.00 | 0.00 | 6792.11 | 0.00 |
| Xie, Franklin, A,17747 | 2743.53 | 0.00 | 0.00 | 2181.56 | 561.97 |
| Mr., Thompson, Austin,12513 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Moreno, Albert,12402 | 5218.40 | 0.00 | 0.00 | 2049.10 | 3169.30 |
| Rubio, Jerome, L,14792 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Thompson, Morgan, Q,24011 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Zeng, Kelvin, A,26207 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Raje, Karl,19362 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Wood, Riley,14705 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Rai, Alisha,26848 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Diaz, Erik, S,11565 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Ashe, Francisco, W,12335 | 6912.60 | 0.00 | 0.00 | 6912.60 | 0.00 |
| Carlson, Arthur, P,11343 | 8221.99 | 0.00 | 3399.99 | 2379.97 | 2442.03 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rodriguez, Jay, M,28411 | 134.95 | 0.00 | 0.00 | 134.95 | 0.00 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Ramos, Latasha, L,22540 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Guo, Stacey,24207 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Jimenez, Diana, M,17776 | 72.25 | 0.00 | 0.00 | 0.00 | 72.25 |
| Deng, Sharon, A,26893 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Chow, Jamie,27815 | 110.46 | 0.00 | 0.00 | 110.46 | 0.00 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Huang, Clarence, C,19341 | 3498.78 | 0.00 | 0.00 | 3498.78 | 0.00 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Blanco, Joe,25675 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Zhao, Omar,27927 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Rodriguez, Ann, S,12315 | 6803.13 | 0.00 | 0.00 | 6803.13 | 0.00 |
| Diaz, Reginald, A,24581 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Clark, Marcus, G,27958 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Anand, Alejandro, R,28899 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Morris, Caitlin,19416 | 3476.39 | 0.00 | 0.00 | 3476.39 | 0.00 |
| Carlson, Robyn, M,14183 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 |
| Price, Wyatt,12336 | 78.98 | 0.00 | 0.00 | 28.99 | 49.99 |
| Ortega, Jésus, L,16542 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Sara, Arthur, D,23753 | 1193.45 | 0.00 | 0.00 | 0.00 | 1193.45 |
| Kumar, Maurice, L,22600 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Chandra, Sergio, A,22837 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Lopez, Morgan, F,19466 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Schmidt, Theresa,21854 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Hall, Destiny, G,25615 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Torres, Hector, E,17700 | 2805.53 | 0.00 | 0.00 | 2805.53 | 0.00 |
| Liu, Stacey, A,13557 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Munoz, Arthur, L,22608 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Patel, Chelsea, P,19938 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Max,26360 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Stewart, Natalie, F,17710 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| King, Adam, M,16932 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Shan, Cristina,14783 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Goel, Shawn, L,19058 | 4524.48 | 0.00 | 0.00 | 2181.56 | 2342.92 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Andersen, Dale, B,14992 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chen, Krystal, D,13530 | 186.28 | 0.00 | 0.00 | 0.00 | 186.28 |
| Sara, Erick, M,25448 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Dominguez, Lawrence, C,17225 | 6986.87 | 0.00 | 0.00 | 2181.56 | 4805.31 |
| Srini, Molly, L,27790 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Tang, Brad,25489 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Thompson, Benjamin,19435 | 3457.77 | 0.00 | 0.00 | 3457.77 | 0.00 |
| Zhang, Cedric, D,26966 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Suri, Brenda, D,22643 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Alvarez, Erika,15615 | 70.24 | 0.00 | 0.00 | 0.00 | 70.24 |
| Diaz, Jaime, A,17795 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Nara, Gilbert, O,28425 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 8.99 | 36.27 |
| She, Todd,23442 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Ye, Omar,21020 | 2497.96 | 0.00 | 0.00 | 782.99 | 1714.97 |
| Deng, Misty,14861 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Rana, Andre,27904 | 156.76 | 0.00 | 0.00 | 156.76 | 0.00 |
| Sai, Tabitha,25741 | 567.76 | 0.00 | 0.00 | 567.76 | 0.00 |
| Liang, Jeffery,15711 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Zhu, Karen, R,18012 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Rubio, Dwayne, D,28527 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Gill, Darren, M,11408 | 34.47 | 0.00 | 0.00 | 34.47 | 0.00 |
| Harris, Jonathan,26220 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Patel, Ebony,25531 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Wu, Trisha,26404 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Torres, Nelson, F,25804 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Ye, Randy, G,29367 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Patel, Troy,14968 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Carlson, Kendra,18044 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Patterson, Melanie,28898 | 69.46 | 0.00 | 0.00 | 69.46 | 0.00 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Scott, Jason,22557 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Arun, Emmanuel, R,28463 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Prasad, Regina, A,24192 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Alexander, Riley,22799 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Beck, Clayton,11579 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| She, Omar, K,15448 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Travers, Linda,29420 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Stewart, Megan, L,11413 | 7189.75 | 0.00 | 3399.99 | 2350.96 | 1438.80 |
| Shan, Nichole, K,19461 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Romero, Robyn, C,27802 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Garcia, Kristina,25446 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Cook, Carlos, R,26955 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Liu, Mandy,17888 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Black, Nichole,22422 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Blanco, Francis, J,25750 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Randall, Kristi,13665 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Hernandez, Mason, C,27782 | 47.97 | 0.00 | 0.00 | 47.97 | 0.00 |
| Zeng, Darryl, C,20929 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Lin, Candice, K,19506 | 3480.38 | 0.00 | 0.00 | 1000.44 | 2479.94 |
| McDonald, George,11394 | 8161.97 | 0.00 | 3399.99 | 2342.92 | 2419.06 |
| Carlson, Kristine, C,28753 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Sanz, Mallory,14938 | 107.97 | 0.00 | 0.00 | 78.98 | 28.99 |
| Sanz, Randall, D,22539 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Romero, Theodore,23747 | 1142.42 | 0.00 | 0.00 | 0.00 | 1142.42 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 607.96 | 0.00 |
| Chander, Christy, E,21548 | 36.93 | 0.00 | 0.00 | 0.00 | 36.93 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Sun, Omar, D,25783 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Zheng, Mandy,24721 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Ramos, Cheryl, A,25682 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
Generated 2025-11-06 20:34:51.476 UTC