[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| King, Wyatt,22671 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Torres, Victor,18030 | 64.97 | 0.00 | 0.00 | 64.97 | 0.00 |
| Dominguez, Teresa, C,20963 | 42.93 | 0.00 | 0.00 | 42.93 | 0.00 |
| Patterson, Melanie,28898 | 69.46 | 0.00 | 0.00 | 69.46 | 0.00 |
| Hernandez, Lori,18186 | 139.44 | 0.00 | 0.00 | 0.00 | 139.44 |
| Jackson, Kayla, R,20060 | 3142.45 | 699.10 | 0.00 | 0.00 | 2443.35 |
| Schmidt, Gina,16260 | 3001.02 | 0.00 | 2181.56 | 0.00 | 819.46 |
| Patel, Manuel, M,20889 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Yuan, Alison, K,24574 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Navarro, Robin, J,28696 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Kumar, Corey,15354 | 8297.29 | 0.00 | 3578.27 | 0.00 | 4719.02 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Chen, Jeffery, C,16827 | 7205.36 | 0.00 | 0.00 | 2443.35 | 4762.01 |
| Smith, Jacob, A,22418 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Muñoz, Armando, E,19906 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ruiz, Derrick, C,12634 | 6787.76 | 0.00 | 0.00 | 4490.48 | 2297.28 |
| Parker, Haley,14694 | 156.94 | 0.00 | 0.00 | 78.98 | 77.96 |
| Moreno, Reginald, H,16050 | 76.94 | 0.00 | 0.00 | 39.98 | 36.96 |
| Yang, Marshall, E,12564 | 110.75 | 0.00 | 0.00 | 36.27 | 74.48 |
| Arun, Andre, E,12287 | 5720.37 | 0.00 | 0.00 | 3331.92 | 2388.45 |
| Sanz, Joanna, L,25732 | 638.95 | 0.00 | 0.00 | 638.95 | 0.00 |
| Carlson, Felicia,19502 | 3565.36 | 0.00 | 0.00 | 3565.36 | 0.00 |
| Anand, Dustin,14535 | 123.47 | 0.00 | 0.00 | 123.47 | 0.00 |
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 42.93 | 0.00 |
| Morgan, Angel, G,24835 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Raje, Jerry, E,21848 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Sharma, Nichole, M,14692 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 3295.26 | 2329.99 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 0.00 | 3693.28 |
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Wu, Colleen,19291 | 28.98 | 0.00 | 0.00 | 28.98 | 0.00 |
| Hughes, Kayla,14982 | 152.45 | 0.00 | 0.00 | 118.47 | 33.98 |
| Deng, Yolanda,28427 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Raji, Barbara,24019 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Raman, Kristina,26932 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| She, Deborah,25576 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Martin, Darren,22695 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Xu, Gilbert,22554 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Blanco, Alfredo, T,17626 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Mr., Sneath, Timothy,17708 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Liang, Wesley, A,12123 | 5837.84 | 0.00 | 2049.10 | 2351.96 | 1436.78 |
| Sun, Alejandro, B,23923 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Kumar, Nicolas, R,12292 | 5027.86 | 0.00 | 0.00 | 4464.09 | 563.77 |
| Martinez, Bryant,19471 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Carlson, Robyn, M,14183 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 |
| Gonzales, Isabella, R,14815 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Smith, Ethan,14530 | 72.86 | 0.00 | 0.00 | 36.59 | 36.27 |
| Nath, Tonya,24847 | 2552.82 | 0.00 | 0.00 | 0.00 | 2552.82 |
| Lu, Colin, H,21069 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Rivera, Katelyn,23948 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Rai, Kelvin, M,26833 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Henderson, Tristan,12224 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Mr., Thompson, Austin,12513 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Brooks, Haley, S,17193 | 134.96 | 0.00 | 0.00 | 74.98 | 59.98 |
| Sai, Jillian,22518 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Muñoz, Kari,19520 | 87.97 | 0.00 | 0.00 | 87.97 | 0.00 |
| Tang, Nicolas, S,12282 | 5111.44 | 0.00 | 0.00 | 2791.45 | 2319.99 |
| Chande, Nina, D,19263 | 1587.41 | 0.00 | 1000.44 | 0.00 | 586.97 |
| Sr., Cai, Ramón, S,16599 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Prasad, Rachael, M,22535 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
Generated 2025-11-03 06:40:05.393 UTC