[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Castro, Jacquelyn,21093 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Vazquez, Stacy,22559 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Adams, Ian, C,29422 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Tang, Brad,25489 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| She, Omar, K,15448 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Mrs., West, Alyssa,23219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Brendan,16250 | 4511.54 | 0.00 | 0.00 | 2181.56 | 2329.98 |
| He, Warren, L,17192 | 6977.58 | 0.00 | 0.00 | 2181.56 | 4796.02 |
| Alexander, Justin, M,12272 | 5139.73 | 0.00 | 0.00 | 2822.76 | 2316.97 |
| Ruiz, Marc, D,12545 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Ma, Leah, H,14553 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Chandra, Ronald, H,20801 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Serrano, Michele, R,19483 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Guo, Stacey,24207 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rai, Alicia, M,28914 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Carlson, Derrick, R,28436 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Rowe, Theodore,17794 | 2745.82 | 0.00 | 0.00 | 2181.56 | 564.26 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Yang, Jessie, E,20053 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Rodriguez, Deanna,25611 | 564.48 | 0.00 | 0.00 | 564.48 | 0.00 |
| Gonzalez, Rachael, M,23636 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Alexander, Ana, R,22637 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Zhao, Colleen, L,16407 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Nelson, Haley,27185 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, April, L,14981 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Hall, Jenna,24015 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Deng, Dale,28399 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Collins, Blake,11610 | 6786.44 | 0.00 | 2071.42 | 0.00 | 4715.02 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Ramos, Janet, B,20596 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Morgan, Angel, G,24835 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Andersen, Leonard,17772 | 2846.00 | 0.00 | 0.00 | 2181.56 | 664.44 |
| Sai, Jermaine, G,14934 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Sanz, Krista,27806 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Wright, Elijah, I,25577 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Madan, Cindy, R,12259 | 86.75 | 0.00 | 0.00 | 0.00 | 86.75 |
| Andersen, April, C,20973 | 193.98 | 0.00 | 0.00 | 0.00 | 193.98 |
| Hu, Sandra, N,27817 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Xie, Sheena,18041 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Patel, Chelsea, P,19938 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhang, Benjamin, F,12593 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Munoz, Arthur, L,22608 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Gao, Dennis,18187 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| King, Adam, M,16932 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Watson, Ian, G,26398 | 1758.95 | 0.00 | 0.00 | 0.00 | 1758.95 |
| Watson, Jan, K,13680 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Luo, Alisha,24534 | 2533.93 | 0.00 | 0.00 | 0.00 | 2533.93 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Ruiz, Jaime, J,25609 | 565.47 | 0.00 | 0.00 | 565.47 | 0.00 |
| Munoz, Kristine,16446 | 3093.03 | 0.00 | 0.00 | 2181.56 | 911.47 |
| Navarro, Shannon, R,15106 | 8421.28 | 0.00 | 3578.27 | 0.00 | 4843.01 |
| Hughes, Adam,24546 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Vance, Veronica, G,16575 | 6994.57 | 0.00 | 0.00 | 2181.56 | 4813.01 |
| Morris, Caitlin,19416 | 3476.39 | 0.00 | 0.00 | 3476.39 | 0.00 |
| Gonzales, Katherine, R,13408 | 6792.12 | 0.00 | 0.00 | 2049.10 | 4743.02 |
| Hernandez, Joanna,19360 | 3511.76 | 0.00 | 0.00 | 3511.76 | 0.00 |
Generated 2025-12-21 00:56:52.447 UTC