[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arun, Virginia,25655 | 571.72 | 0.00 | 0.00 | 571.72 | 0.00 |
| Xie, Katrina, M,26897 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Nara, Jaime, D,13262 | 86.95 | 0.00 | 0.00 | 77.96 | 8.99 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Dominguez, Deanna,23779 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Martinez, Molly, S,13603 | 133.94 | 0.00 | 0.00 | 83.97 | 49.97 |
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 34.99 | 27.77 |
| Deng, Nichole,19933 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Munoz, Danny,19355 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Suri, Cynthia,22589 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gonzalez, Bob, S,24569 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Gao, Marshall,25782 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Hernandez, Gabriel, J,13805 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Lin, Franklin, M,24557 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Miller, Grace,22502 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Suri, Andre, D,24189 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ruiz, Roy, L,28704 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Goldberg, Nicolas,27789 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Reed, Jesse, E,22429 | 1777.95 | 0.00 | 0.00 | 0.00 | 1777.95 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Foster, Mya, M,23230 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Sharma, Grant, R,23966 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Powell, Gavin, M,28530 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Madan, Carolyn,26222 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Ma, Stacey,21840 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Liu, Roger, E,20058 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| She, Donna, D,19346 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Garcia, Tammy, A,12293 | 86.76 | 0.00 | 0.00 | 0.00 | 86.76 |
| Smith, Hunter, L,21507 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| King, Adam, M,16932 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Munoz, Roberto,17628 | 106.24 | 0.00 | 0.00 | 7.28 | 98.96 |
| Jai, Christy, G,26979 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Hernandez, Larry,17840 | 228.96 | 0.00 | 0.00 | 0.00 | 228.96 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Ma, Suzanne, A,26947 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Brooks, Savannah, R,24558 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Malhotra, Ebony,11589 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Wright, Amber, L,23924 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Alvarez, Lance, J,16190 | 79.25 | 0.00 | 0.00 | 7.28 | 71.97 |
| Miller, Olivia, H,26860 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Thomas, Ryan,22532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Pal, Corey,25774 | 2537.32 | 0.00 | 0.00 | 0.00 | 2537.32 |
| Alonso, Francis, J,21738 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Xu, Omar, R,19279 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Lopez, Jonathan, D,15103 | 107.85 | 0.00 | 0.00 | 71.58 | 36.27 |
| Raje, Damien, S,25784 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanchez, Heidi,28438 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Tang, Kenneth,28477 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Srini, Molly, L,27790 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Rana, Lydia,29395 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zeng, Kelli, M,22825 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Roberts, Nathan,29470 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| She, Omar, K,15448 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Martin, Gloria, A,12325 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Shan, Nichole, K,19461 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| She, Kelvin, T,27002 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Liu, Mandy,17888 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Jai, Christine, J,14814 | 128.46 | 0.00 | 0.00 | 128.46 | 0.00 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Gutierrez, Kathleen,17786 | 89.46 | 0.00 | 0.00 | 39.98 | 49.48 |
| Alexander, Isabel,22823 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Gill, Julio, R,26993 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Yuan, Barbara,21515 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Sharma, Barbara, D,22421 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Alexander, Ana, R,22637 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Goel, Tracy, J,18178 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Lal, Misty, L,22385 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Nara, Damien, W,26877 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Chandra, Sergio, A,22837 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Patel, Chelsea, P,19938 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Zhou, Curtis,25505 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhao, Rafael,13412 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Diaz, Stephanie,15694 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Zhao, Arturo,19425 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Garcia, Marie,27953 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Martin, Janet, L,24540 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zeng, Brent, S,21110 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Taylor, Grace,24073 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Rowe, Kristi, R,28692 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Rodriguez, Bruce,28473 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Schmidt, Derrick, R,22605 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Martinez, Dalton, M,28413 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| He, Arturo,29369 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Zheng, Mandy,24721 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Ye, Micah, A,20952 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Gonzalez, Raymond, P,28755 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Jai, Kelsey, J,27837 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Ashe, Tasha, W,24881 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhang, Benjamin, F,12593 | 42.97 | 0.00 | 0.00 | 8.99 | 33.98 |
| Hall, Jenna,24015 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Sanz, Latasha,29384 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Smith, Destiny,22428 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Alvarez, Raquel, G,17808 | 159.94 | 0.00 | 0.00 | 64.97 | 94.97 |
| Yang, Bianca, E,28732 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Nara, Terry,27305 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Ms., Shock, Misty,24869 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kumar, Maurice, L,22600 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Romero, Armando, A,12596 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Alonso, Felicia, A,26842 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sun, Rosa,26900 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gutierrez, Roberto,11355 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Martin, Billy, B,26849 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Russell, Natalie, M,20900 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Shan, Alicia,27964 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Xu, Melvin, A,11474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Jai, Terrence,27956 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Martinez, Richard, J,14986 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Gonzalez, Rachael, M,23636 | 2479.94 | 0.00 | 0.00 | 2479.94 | 0.00 |
| Rana, Brett, L,20943 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Blanco, Gina,28918 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Garcia, Douglas,24860 | 2520.31 | 0.00 | 0.00 | 0.00 | 2520.31 |
| Xu, Terrence, L,23743 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
Generated 2025-11-03 23:07:08.394 UTC