[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1031 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| He, Alan, A,12210 | 6825.45 | 0.00 | 0.00 | 2071.42 | 4754.03 |
| Harris, Jonathan,26220 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Cox, Taylor,11436 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Rai, Cassie, R,14194 | 168.93 | 0.00 | 0.00 | 0.00 | 168.93 |
| Sutton, Marshall,20862 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Gonzalez, Bob, S,24569 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Raman, Tammy,12126 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Sharma, Dawn,23987 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Henderson, Hunter, C,14812 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Smith, Destiny,22428 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Lin, Franklin, M,24557 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chandra, Donald,11485 | 7048.30 | 0.00 | 3399.99 | 0.00 | 3648.31 |
| Romero, Armando, A,12596 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Deng, Karla, C,29382 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Nath, Clarence,24050 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Sun, Rosa,26900 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Black, Roger, J,28416 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Wu, Dawn, T,11493 | 6958.80 | 0.00 | 3399.99 | 0.00 | 3558.81 |
| Nara, Jaime, D,13262 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Arthur, Carmen, M,12567 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Hernandez, Gerald, L,24054 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Shen, Casey, D,12503 | 84.46 | 0.00 | 0.00 | 0.00 | 84.46 |
| Butler, Natalie,26401 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Deng, Sharon, A,26893 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Blanco, Francis, J,25750 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Vazquez, Stacy,22559 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-21 22:35:49.881 UTC