[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 14 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Franklin, M,24557 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gomez, Melody,25805 | 2501.31 | 0.00 | 0.00 | 0.00 | 2501.31 |
| Deng, Julie,25631 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Smith, Destiny,22428 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Vance, Regina, M,14984 | 6699.57 | 0.00 | 3578.27 | 0.00 | 3121.30 |
| Chandra, Sergio, A,22837 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Saunders, Cynthia,24537 | 2511.32 | 0.00 | 0.00 | 0.00 | 2511.32 |
| Li, Laura, O,20933 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Sai, Marie, A,24582 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Rivera, Chase,28511 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Nara, Drew, A,26944 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Moreno, Craig, N,14158 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Sanz, Neil, M,22622 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Tang, Kenneth,28477 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Xie, Tara,19912 | 3427.39 | 0.00 | 0.00 | 1000.44 | 2426.95 |
| Ramos, Anne, R,11351 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Gill, Adrienne,14953 | 202.46 | 0.00 | 0.00 | 0.00 | 202.46 |
| Davis, Edward,28896 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
| Bell, Haley, A,29437 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Schmidt, Billy,22434 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Sanz, Joanna, L,25732 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Black, Tara,24216 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Moreno, Reginald, H,16050 | 76.94 | 0.00 | 0.00 | 0.00 | 76.94 |
| Romero, Darren, A,19195 | 1637.38 | 0.00 | 0.00 | 1000.44 | 636.94 |
| Baker, Caleb, F,23968 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Noah, L,14547 | 192.95 | 0.00 | 0.00 | 0.00 | 192.95 |
| Jai, Kate,14706 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Martin, Sabrina, D,25578 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanchez, Brett,12608 | 5689.88 | 0.00 | 0.00 | 2049.10 | 3640.78 |
| Arun, Henry, L,27177 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Diaz, Armando, P,17978 | 3018.01 | 0.00 | 0.00 | 2181.56 | 836.45 |
| Sara, Manuel,12611 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Van, Bryant,13562 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Sanz, Pedro,18168 | 6907.55 | 0.00 | 0.00 | 2181.56 | 4725.99 |
| Jenkins, Blake,28907 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Smith, Hunter, L,21507 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Goel, Christy,26409 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Chen, Dennis, M,17627 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Martin, Derrick,14191 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Sanchez, Edgar,11604 | 6786.12 | 0.00 | 2049.10 | 0.00 | 4737.02 |
| Campbell, Katherine, P,28448 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Mitchell, Isaac,14554 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Romero, Eddie,28883 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Kapoor, Nancy, L,18024 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Huang, Jeffery,25755 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Foster, Jordan, M,20807 | 3249.31 | 0.00 | 0.00 | 782.99 | 2466.32 |
| Patterson, Melanie,28898 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Subram, Cindy, L,23943 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sharma, Nicolas, D,13517 | 5666.38 | 0.00 | 0.00 | 2049.10 | 3617.28 |
Generated 2025-12-23 16:41:58.369 UTC