[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 10 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Yuan, Clarence, D,24047 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Shan, Nichole, K,19461 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Mehta, Ronald, F,17649 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Malhotra, Ebony,11589 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Ross, Gabrielle, J,19253 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Morgan, Sean,14993 | 152.94 | 0.00 | 0.00 | 0.00 | 152.94 |
| Wu, Ramon, M,27955 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 0.00 | 163.94 |
| Arun, Henry, L,27177 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Saunders, Cynthia,24537 | 2511.32 | 0.00 | 0.00 | 0.00 | 2511.32 |
| Mr., Thompson, Austin,12513 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Jordan, Terrance, B,16546 | 3036.53 | 0.00 | 0.00 | 2181.56 | 854.97 |
| Schmidt, Kristina,12318 | 6808.15 | 0.00 | 0.00 | 2049.10 | 4759.05 |
| Li, Leah,12871 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Yuan, Shawn, P,27762 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Navarro, Lawrence,27939 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Mehta, Ruth,15702 | 6917.54 | 0.00 | 2181.56 | 0.00 | 4735.98 |
| Cox, Andrea,13830 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Jones, David, D,20866 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Arun, Emmanuel, R,28463 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sanchez, Gerald,24144 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ye, Omar,21020 | 2497.96 | 0.00 | 0.00 | 782.99 | 1714.97 |
| Shen, Kara, C,23628 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Mitchell, Jose, F,24568 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Guo, Crystal,19379 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Shan, Kathryn, K,28916 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chandra, Whitney,15712 | 51.57 | 0.00 | 0.00 | 0.00 | 51.57 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Serrano, Erika,12394 | 5635.91 | 0.00 | 0.00 | 2049.10 | 3586.81 |
| Luo, Leonard, A,25582 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Lopez, Allen, O,13821 | 5940.54 | 0.00 | 3578.27 | 0.00 | 2362.27 |
| Thompson, Benjamin,19435 | 3457.77 | 0.00 | 0.00 | 3457.77 | 0.00 |
| Hall, Jenna,24015 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Bhat, Drew,14820 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Carlson, Kendra,18044 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Raji, Nina, W,29480 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Romero, Darren, A,19195 | 1637.38 | 0.00 | 0.00 | 1000.44 | 636.94 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Lu, Mandy,14988 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Liang, Jeffery,15711 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Stone, Stephanie, S,19060 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Fernandez, Heidi, L,22798 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Rubio, Clinton, A,25612 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Serrano, Michele, R,19483 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Wang, Dawn, L,27152 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Blanco, Alfredo, T,17626 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Smith, Hunter, L,21507 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
Generated 2025-12-22 05:55:11.380 UTC