[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1127 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2071.42 | 3090.31 |
| Bennett, Morgan,15097 | 8377.09 | 0.00 | 3578.27 | 0.00 | 4798.82 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2049.10 | 3205.78 |
| Long, Maria,16036 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Zhou, Lisa, L,13809 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 0.00 | 4752.52 |
| Patel, Patricia,20569 | 3114.06 | 0.00 | 699.10 | 0.00 | 2414.96 |
| Carlson, Lee, S,21079 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Andersen, Brad, S,26992 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 0.00 | 3693.28 |
| Robinson, Brandon, J,15661 | 5208.04 | 0.00 | 3578.27 | 0.00 | 1629.77 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Patterson, Margaret, J,13507 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Mehta, Ruth,15702 | 6917.54 | 0.00 | 2181.56 | 0.00 | 4735.98 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 0.00 | 4718.04 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Tang, Jaclyn, K,21060 | 2508.47 | 0.00 | 0.00 | 782.99 | 1725.48 |
| Chen, Jessie,24069 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Stewart, Natalie, F,17710 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Subram, Meagan, W,11573 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Muñoz, Dana,28459 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Beck, Clayton,11579 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Garcia, Tabitha,27778 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Randall, Kristi,13665 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Zheng, Leah, R,12627 | 110.94 | 0.00 | 0.00 | 0.00 | 110.94 |
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Subram, Cesar, L,11475 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Suri, Marco,16454 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
Generated 2026-01-04 08:53:42.380 UTC