[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 62 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Schmidt, Kristina,12318 | 6808.15 | 0.00 | 0.00 | 2049.10 | 4759.05 |
| Zhu, Laura, M,29439 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Vance, Francisco, A,20972 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sara, Manuel,12611 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Nara, Gilbert, O,28425 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zhou, Leah, L,22309 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Alonso, Jaime,15062 | 6684.59 | 0.00 | 3578.27 | 0.00 | 3106.32 |
| Li, Steve,21137 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Tang, Tonya,20917 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Chapman, Pedro,17785 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Scott, Kyle, D,11419 | 231.75 | 0.00 | 0.00 | 0.00 | 231.75 |
| Ray, Harold, A,13516 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Gill, Marvin, M,17821 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2826.44 | 2342.92 |
| Alvarez, Casey, A,28557 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Liang, Cedric, R,19941 | 3078.06 | 699.10 | 0.00 | 0.00 | 2378.96 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Anand, Wayne, H,22686 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Black, Roger, J,28416 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Yang, Omar,12566 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Perez, Manuel, C,13777 | 7147.07 | 0.00 | 3578.27 | 0.00 | 3568.80 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Martinez, Brandy, L,12865 | 114.23 | 0.00 | 0.00 | 0.00 | 114.23 |
| Miller, Nathan, l,19418 | 3476.39 | 0.00 | 0.00 | 3476.39 | 0.00 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 0.00 | 4752.52 |
| Alvarez, Deanna, K,24720 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
Generated 2025-12-21 19:44:31.217 UTC