[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1126 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shen, Damien, C,14964 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Gray, Devin,16584 | 172.95 | 0.00 | 0.00 | 0.00 | 172.95 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Kelly, Dalton, L,15634 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Schmidt, Kristina,12318 | 6808.15 | 0.00 | 0.00 | 2049.10 | 4759.05 |
| Yuan, Barbara,21515 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Fernandez, Heidi, L,22798 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Washington, Julia, R,20875 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Luo, Terry, H,26850 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Ma, Damien,15612 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Torres, Hector, E,17700 | 2805.53 | 0.00 | 0.00 | 2805.53 | 0.00 |
| Goel, Tracy, J,18178 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| 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 |
| Pal, Mohamed,20550 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Andersen, Leonard,17772 | 2846.00 | 0.00 | 0.00 | 2181.56 | 664.44 |
| Zhao, Sandra, S,22503 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Diaz, Janet, R,25626 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Black, Raul,25301 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Holt, Dale, C,23618 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Raji, Tracy,22439 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Ramos, Linda,23598 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Lopez, Geoffrey, A,29451 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Wu, Cedric, E,21025 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Schmidt, Meredith,25499 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Patel, Heidi, R,23225 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Torres, Shannon,12612 | 5657.91 | 0.00 | 0.00 | 2049.10 | 3608.81 |
| Rana, Lydia,29395 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lin, Lacey,13815 | 114.55 | 0.00 | 0.00 | 0.00 | 114.55 |
| Fernandez, Jillian, K,12599 | 5649.21 | 0.00 | 0.00 | 2071.42 | 3577.79 |
| Roberts, Nathan,29470 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Jai, Christine, J,14814 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Li, Laura, O,20933 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Martin, Victor, L,26885 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Deng, Leonard,27821 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Luo, Chad, R,21040 | 2566.95 | 0.00 | 0.00 | 2566.95 | 0.00 |
| Ross, Hailey, C,13612 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Howard, Angel, A,23223 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ramos, Jill,21039 | 2483.98 | 0.00 | 0.00 | 2483.98 | 0.00 |
| Gill, Julio, R,26993 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Blanco, Joe,25675 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Romero, Joe, J,17943 | 2781.54 | 0.00 | 0.00 | 2181.56 | 599.98 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Kumar, Roger, C,15922 | 148.20 | 0.00 | 0.00 | 0.00 | 148.20 |
| Rodriguez, Noah, J,22325 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Romero, Melinda,12260 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Ruiz, Briana,20906 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Martinez, Tabitha,26865 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Scott, Jason,22557 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cox, Cole, M,25315 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Raman, Martin,17709 | 78.95 | 0.00 | 0.00 | 0.00 | 78.95 |
| Huang, Alvin,12491 | 86.58 | 0.00 | 0.00 | 0.00 | 86.58 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Baker, Seth,21520 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Jai, Lindsey, W,23971 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Xu, Omar, A,22596 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
Generated 2025-12-23 05:49:03.029 UTC