[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Candice, K,19506 | 3480.38 | 0.00 | 0.00 | 1000.44 | 2479.94 |
| Stewart, Natalie, F,17710 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| She, Clayton,13785 | 121.83 | 0.00 | 0.00 | 0.00 | 121.83 |
| Alvarez, Theodore,25690 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhao, Eugene,12328 | 6792.11 | 0.00 | 0.00 | 2049.10 | 4743.01 |
| Sanz, Natasha,14839 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Sanchez, Brian, F,20931 | 3273.17 | 0.00 | 0.00 | 782.99 | 2490.18 |
| Hayes, Seth, C,17757 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Dominguez, Deanna,23779 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Raman, Holly,25477 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Williams, Abigail, M,16938 | 3110.05 | 0.00 | 0.00 | 2181.56 | 928.49 |
| Scott, Dalton,14975 | 5957.22 | 0.00 | 3578.27 | 0.00 | 2378.95 |
| Anderson, Devin, A,22822 | 2475.95 | 0.00 | 0.00 | 2475.95 | 0.00 |
| Wang, Alvin,19939 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Thomas, Ryan,22532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Rana, Barry,14832 | 5938.24 | 0.00 | 3578.27 | 0.00 | 2359.97 |
| Liu, Jorge, J,20592 | 3113.22 | 0.00 | 782.99 | 0.00 | 2330.23 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Black, Nicolas,23945 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raman, Martin,17709 | 78.95 | 0.00 | 0.00 | 0.00 | 78.95 |
| Sun, Rosa,26900 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| He, Arturo,29369 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Sanchez, Kari, T,19262 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Ashe, Bruce,12264 | 5662.90 | 0.00 | 0.00 | 3292.94 | 2369.96 |
| Lu, Colin, H,21069 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Zhou, Alejandro, A,12304 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Lu, Mandy,14988 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Malhotra, Troy,11569 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Roberts, Mackenzie,23599 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Cooper, Kimberly, J,22457 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 0.00 | 163.94 |
| Campbell, Jackson,11575 | 6806.12 | 0.00 | 2049.10 | 0.00 | 4757.02 |
| Sanz, Krista,27806 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Suarez, Reginald,18177 | 7043.56 | 0.00 | 0.00 | 2181.56 | 4862.00 |
| Gomez, Joy, J,12658 | 6863.44 | 0.00 | 0.00 | 2071.42 | 4792.02 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Tang, Nichole, C,15630 | 5136.37 | 0.00 | 3578.27 | 806.76 | 751.34 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Anand, Tonya, A,27141 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ramos, Erik, M,25312 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| He, Cedric, W,25298 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chande, Tamara, L,28693 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lopez, Ronald,17855 | 189.96 | 0.00 | 0.00 | 0.00 | 189.96 |
| Taylor, Grace,24073 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Sara, Arthur, D,23753 | 1193.45 | 0.00 | 0.00 | 0.00 | 1193.45 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nath, Leonard, L,12637 | 6845.12 | 0.00 | 0.00 | 2049.10 | 4796.02 |
| Moore, Anna, A,12744 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Chander, Priscilla,16530 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Diaz, Krista,28913 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Hughes, Kayla,14982 | 152.45 | 0.00 | 0.00 | 0.00 | 152.45 |
| Bhat, Drew,14820 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Black, Mario, M,27905 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Lin, Randy,14540 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| James, Jade, M,26400 | 132.98 | 0.00 | 0.00 | 0.00 | 132.98 |
| Smith, Hunter, L,21507 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
Generated 2025-12-21 20:27:10.972 UTC