[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Huang, Alvin,12491 | 86.58 | 0.00 | 0.00 | 0.00 | 86.58 |
| Serrano, Walter, G,12299 | 4977.36 | 0.00 | 0.00 | 2071.42 | 2905.94 |
| Gutierrez, Kellie, K,17966 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Gutierrez, Lori,24065 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Madan, Carolyn,26222 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Martin, Jacquelyn, M,17763 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Pal, Kristin, E,26956 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Evans, Hunter,25493 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Kapoor, Pamela,20825 | 3226.34 | 0.00 | 0.00 | 782.99 | 2443.35 |
| He, Franklin, K,18127 | 6982.07 | 0.00 | 0.00 | 2181.56 | 4800.51 |
| Yang, Ryan,28723 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| He, Suzanne,16593 | 101.76 | 0.00 | 0.00 | 0.00 | 101.76 |
| Tang, Kenneth,28477 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moreno, Paula, W,13554 | 5641.25 | 0.00 | 0.00 | 2071.42 | 3569.83 |
| Martin, Gloria, A,12325 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Gill, Julio, R,26993 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Luo, Christy,16277 | 3010.03 | 0.00 | 0.00 | 2181.56 | 828.47 |
| Serrano, Larry,21516 | 3102.25 | 0.00 | 0.00 | 782.99 | 2319.26 |
| Jones, Brianna,25546 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Wu, Crystal, W,22672 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Thompson, Benjamin,19435 | 3457.77 | 0.00 | 0.00 | 3457.77 | 0.00 |
| Jai, Damien,14806 | 242.94 | 0.00 | 0.00 | 0.00 | 242.94 |
| Dominguez, Victor, K,14784 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Randall, Mayra,27909 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Gomez, Joy, J,12658 | 6863.44 | 0.00 | 0.00 | 2071.42 | 4792.02 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Srini, Whitney,11560 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Zeng, Sandra,25608 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Blanco, Mathew, B,12595 | 40.27 | 0.00 | 0.00 | 0.00 | 40.27 |
| Kelly, Brianna, C,16945 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Rubio, Jill,13838 | 140.55 | 0.00 | 0.00 | 0.00 | 140.55 |
| Garcia, Bruce, B,18037 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Jiménez, Javier, M,22687 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Andersen, Brad, S,26992 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Shen, Bethany, C,17903 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Bailey, Ariana, J,13691 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Munoz, Meghan, P,27810 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Jai, Kelsey, J,27837 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Alvarez, Krista,19467 | 3485.38 | 0.00 | 0.00 | 1000.44 | 2484.94 |
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Serrano, Tanya,23750 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Lopez, Andre,11434 | 70.46 | 0.00 | 0.00 | 0.00 | 70.46 |
| Xu, Laura, D,16287 | 4538.84 | 0.00 | 0.00 | 2181.56 | 2357.28 |
| Pal, Corey,25774 | 2537.32 | 0.00 | 0.00 | 0.00 | 2537.32 |
| Nara, Gilbert, O,28425 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Zhu, Autumn,14840 | 157.96 | 0.00 | 0.00 | 0.00 | 157.96 |
| Li, Caleb,22640 | 1149.47 | 0.00 | 0.00 | 0.00 | 1149.47 |
| Bryant, Alexandra,12598 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Subram, Jermaine,28731 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
Generated 2025-12-23 22:11:12.797 UTC