[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Stone, Stephanie, S,19060 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Deng, Nichole,19933 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Garcia, Marie,27953 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Malhotra, Dominique,12460 | 5678.91 | 0.00 | 0.00 | 2049.10 | 3629.81 |
| Blanco, Jessie, R,23608 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Sun, Heather,28729 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Gonzalez, Dominic, L,13693 | 7171.58 | 0.00 | 3578.27 | 0.00 | 3593.31 |
| Suri, Carla,25547 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Torres, Adrienne, C,11482 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Ms., Song, Lolan,19073 | 4760.32 | 0.00 | 0.00 | 2443.35 | 2316.97 |
| Torres, Cheryl, T,25727 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Liang, Marshall, J,25447 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Yuan, Barbara,21515 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Zimmerman, Curtis, T,14702 | 6729.57 | 0.00 | 3578.27 | 0.00 | 3151.30 |
| Sara, Henry, L,20892 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Patel, Manuel, M,20889 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ramos, Jamie, L,27852 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Vance, Joe, L,28877 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Goel, Kara,16465 | 3271.79 | 0.00 | 0.00 | 2443.35 | 828.44 |
| Goel, Sharon, M,19430 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Gomez, Robyn,16046 | 3963.14 | 0.00 | 2443.35 | 0.00 | 1519.79 |
| Srini, Molly, L,27790 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Parker, Haley,14694 | 156.94 | 0.00 | 0.00 | 0.00 | 156.94 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gutierrez, Gina, A,21092 | 2511.26 | 0.00 | 0.00 | 782.99 | 1728.27 |
| Yuan, Drew, R,21679 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Romero, Juan, A,16324 | 3282.81 | 0.00 | 0.00 | 2443.35 | 839.46 |
| Sanders, Richard, D,21511 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2049.10 | 3205.78 |
| Mehta, Whitney, T,24197 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ye, Stacey,12568 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Sun, Alejandro, B,23923 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Raje, Damien, S,25784 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Schmidt, Dana, S,25641 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Stewart, Natalie, F,17710 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Zhang, Trisha,18156 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Vance, Francisco, A,20972 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Johnsen, Jerome,28367 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Gutierrez, Jésus, E,16437 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Martin, Billy, B,26849 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rana, Cesar, L,19044 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Raji, Lindsay, E,22669 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Martinez, Michele, L,19247 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Blanco, Albert, W,13581 | 8374.79 | 3578.27 | 0.00 | 0.00 | 4796.52 |
| Raman, Andre, D,24079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 0.00 | 3693.28 |
| Prasad, Sergio, J,19290 | 1605.40 | 0.00 | 0.00 | 1000.44 | 604.96 |
| Bailey, Xavier,12305 | 4940.39 | 0.00 | 0.00 | 2071.42 | 2868.97 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Prasad, Virginia,17933 | 3103.31 | 0.00 | 0.00 | 2443.35 | 659.96 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Blanco, Alfredo, T,17626 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Lopez, Courtney,20839 | 2511.26 | 0.00 | 0.00 | 782.99 | 1728.27 |
| Jimenez, Robyn, M,12861 | 4394.06 | 0.00 | 0.00 | 2049.10 | 2344.96 |
| Serrano, Sheila, C,21018 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Wu, Colleen,19291 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Brooks, Sara, A,12288 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
Generated 2025-12-22 00:26:16.790 UTC