[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nara, Casey, E,17812 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| Alonso, Kendra, C,16427 | 2975.02 | 0.00 | 0.00 | 2975.02 | 0.00 |
| Raman, Lydia,26868 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Liu, Vincent,20848 | 2558.46 | 0.00 | 0.00 | 782.99 | 1775.47 |
| Liang, Jeffery,15711 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Parker, Wyatt,25325 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Alvarez, Raquel, G,17808 | 159.94 | 0.00 | 0.00 | 0.00 | 159.94 |
| Kapoor, Sergio, E,19392 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Kumar, Carly, R,24712 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Cox, Melanie, C,12496 | 204.58 | 0.00 | 0.00 | 0.00 | 204.58 |
| Prasad, Virginia,17933 | 3103.31 | 0.00 | 0.00 | 2443.35 | 659.96 |
| Guo, Stacey,24207 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Naomi,25686 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Nelson, Luke, E,21027 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Coleman, Gabriel, B,17706 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Deng, Brendan,25726 | 663.44 | 0.00 | 0.00 | 0.00 | 663.44 |
| Gutierrez, Audrey,17829 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| Collins, Richard, S,16256 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Nara, Drew, A,26944 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ma, Suzanne, A,26947 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Ye, Rosa, C,19940 | 3440.43 | 0.00 | 0.00 | 1000.44 | 2439.99 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 0.00 | 163.94 |
| Kumar, Corey,15354 | 8297.29 | 0.00 | 3578.27 | 0.00 | 4719.02 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Yuan, Barbara,21515 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Suarez, Shannon, R,12633 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Chandra, Donald,11485 | 7048.30 | 0.00 | 3399.99 | 0.00 | 3648.31 |
| She, Omar, K,15448 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Brown, Richard, M,29357 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Nath, Clarence,24050 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Prasad, Frederick,17810 | 87.94 | 0.00 | 0.00 | 0.00 | 87.94 |
| Diaz, Alexandria,19926 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Audrey,13791 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Lin, Randy,14540 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Shan, Aaron,20730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Malhotra, Ruth, D,16321 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Alonso, Eddie, L,16420 | 2959.00 | 0.00 | 0.00 | 2181.56 | 777.44 |
| Luo, Bonnie,19337 | 1575.42 | 0.00 | 0.00 | 1000.44 | 574.98 |
| Vazquez, Stacy,22559 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vazquez, Carrie,29419 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Mitchell, Isaac,14554 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Ye, Kelli,19470 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Srini, Ronald, E,16467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chandra, Whitney,15712 | 51.57 | 0.00 | 0.00 | 0.00 | 51.57 |
| Guo, Crystal,19379 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Deng, Chad,22611 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Gomez, Beth, C,13254 | 6801.13 | 0.00 | 0.00 | 2049.10 | 4752.03 |
| Chen, Wesley, J,29427 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Diaz, Janet, R,25626 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Xie, Alejandro,25781 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhang, Trisha,18156 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Yuan, Bonnie, H,15048 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Rai, Kate,16598 | 7131.40 | 0.00 | 0.00 | 2443.35 | 4688.05 |
| Lin, Curtis, N,21858 | 2492.32 | 0.00 | 0.00 | 2492.32 | 0.00 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
Generated 2025-12-24 08:28:05.022 UTC