[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 23 < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wang, Barbara, M,15652 | 5160.08 | 0.00 | 3578.27 | 0.00 | 1581.81 |
| Johnson, Lucas,13509 | 48.96 | 0.00 | 0.00 | 0.00 | 48.96 |
| Luo, Dale, M,22613 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Yang, Bianca, E,28732 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Suri, Veronica, D,23967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Scott, Mackenzie, L,25676 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Jiménez, Javier, M,22687 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Hill, Miguel, C,22433 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Gutierrez, Jésus, E,16437 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| She, Cara, H,22646 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Blanco, Albert, W,13581 | 8374.79 | 3578.27 | 0.00 | 0.00 | 4796.52 |
| Vazquez, Pedro, A,15686 | 72.58 | 0.00 | 0.00 | 0.00 | 72.58 |
| Cox, Andrea,13830 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Gomez, Meredith,27965 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Nara, Louis, J,26901 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Arun, Roy, W,23620 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Srini, Cesar,11563 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Smith, Jacob, A,22418 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| She, Kelvin, T,27002 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gonzalez, Allen,25572 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Wu, Colleen,19291 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sharma, Dylan,19066 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Sanders, Jessica,17650 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Suarez, Kendra,23615 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Carlson, Melinda,20921 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Goel, Calvin, J,17213 | 179.95 | 0.00 | 0.00 | 0.00 | 179.95 |
| Alonso, Micheal, W,19307 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Deng, Leonard,27821 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Tang, Kelvin,20832 | 2533.97 | 0.00 | 0.00 | 2533.97 | 0.00 |
| Malhotra, Frederick,17951 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Martin, Paula, B,21855 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Gill, Alfredo, M,23629 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Barnes, Vanessa,13810 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Holt, Dale, C,23618 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2826.44 | 2342.92 |
| Pal, Jon, H,15440 | 6736.56 | 0.00 | 3578.27 | 0.00 | 3158.29 |
| Rai, Sheena,29393 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zhu, Autumn,14840 | 157.96 | 0.00 | 0.00 | 0.00 | 157.96 |
| Martin, Jacquelyn, M,17763 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Ms., Sims, Anne, R.,26869 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Moreno, Jamie,22526 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Subram, Allen,17895 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Patel, Joel,27820 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Washington, Isabella,20880 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Martinez, Francisco,11375 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| He, Franklin, K,18127 | 6982.07 | 0.00 | 0.00 | 2181.56 | 4800.51 |
| Arun, Evelyn,27842 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Roberts, Dalton,26387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rai, Kate,16598 | 7131.40 | 0.00 | 0.00 | 2443.35 | 4688.05 |
| Kelly, Dalton, L,15634 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Mehta, Whitney, T,24197 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Yuan, Tasha,20565 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Romero, Jaime, B,28508 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Perez, Jack,19455 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Ruiz, Marc, D,12545 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
Generated 2025-12-23 14:28:58.167 UTC