[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Candice, K,19506 | 3480.38 | 0.00 | 0.00 | 1000.44 | 2479.94 |
| Perez, Meagan, R,21101 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Malhotra, Ebony,11589 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Zhu, Karen, R,18012 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| She, Gilbert,19505 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Anand, Nichole,12508 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Diaz, Jimmy, D,25474 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gutierrez, Raquel, H,28697 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Perez, Bruce, R,16935 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Griffin, Jeremiah,18158 | 6869.61 | 0.00 | 0.00 | 2181.56 | 4688.05 |
| Fernandez, Meagan, C,19448 | 3543.88 | 0.00 | 0.00 | 1000.44 | 2543.44 |
| Lopez, Jermaine,11488 | 8090.33 | 0.00 | 3374.99 | 2322.28 | 2393.06 |
| Raman, Darren, K,22315 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jiménez, Javier, M,22687 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Torres, Adrienne, C,11482 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Rana, Barry,14832 | 5938.24 | 0.00 | 3578.27 | 0.00 | 2359.97 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Liu, Jorge, J,20592 | 3113.22 | 0.00 | 782.99 | 0.00 | 2330.23 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Carlson, Arthur, P,11343 | 8221.99 | 0.00 | 3399.99 | 0.00 | 4822.00 |
| Walker, Madison,17105 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Cox, Melanie, C,12496 | 204.58 | 0.00 | 0.00 | 0.00 | 204.58 |
| Madan, Dominic, F,21847 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Shan, Russell,19500 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Lu, Mandy,14988 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Sun, Trisha,22442 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Arun, Virginia,25655 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Evans, Isaac, A,17186 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Carlson, Dana, H,14863 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Romero, Roy, C,20859 | 2508.97 | 0.00 | 0.00 | 782.99 | 1725.98 |
| Perez, Meredith, A,23597 | 2482.23 | 0.00 | 0.00 | 2482.23 | 0.00 |
| Raje, Bridget, A,19433 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Zeng, Todd, C,12283 | 5582.91 | 0.00 | 0.00 | 3272.94 | 2309.97 |
| Gonzalez, Ruben, A,22468 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Zhao, Amy, C,26416 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Lopez, Martin, E,21864 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Taylor, Charles,13792 | 7216.08 | 0.00 | 3578.27 | 0.00 | 3637.81 |
| Zhou, Leah, L,22309 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Martinez, Brandy, L,12865 | 114.23 | 0.00 | 0.00 | 0.00 | 114.23 |
| Raman, Bryant, S,19048 | 4765.63 | 0.00 | 0.00 | 2443.35 | 2322.28 |
| Travers, Micheal,26397 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Luo, Cassie,16452 | 3071.01 | 0.00 | 0.00 | 2181.56 | 889.45 |
| Lin, Franklin, M,24557 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ye, Jamie, C,16329 | 3272.09 | 0.00 | 2443.35 | 0.00 | 828.74 |
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Hernandez, Kaitlyn, S,25647 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Kapoor, Johnathan,20576 | 3147.96 | 0.00 | 782.99 | 0.00 | 2364.97 |
| Gao, Claudia,13690 | 7162.08 | 0.00 | 3578.27 | 0.00 | 3583.81 |
| Munoz, Walter,21056 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| Shan, Carly,18631 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gutierrez, Wendy,12610 | 101.95 | 0.00 | 0.00 | 0.00 | 101.95 |
| Kelly, Carlos, C,28561 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Prasad, Veronica, J,24199 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Bailey, Garrett,19055 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Jimenez, Michele,13547 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Chandra, Mayra,16453 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
Generated 2025-12-21 15:42:23.497 UTC