[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 26 > < TAKE 32 >
32 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Evans, Hunter,25493 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Perez, Levi,26830 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Patterson, Melanie,28898 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Malhotra, Frederick,17951 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Martin, Sheila,15635 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| Moyer, Felicia, C,28880 | 637.96 | 0.00 | 0.00 | 0.00 | 637.96 |
| Simpson, Lindsay, E,25746 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Subram, Dominique, S,15620 | 5959.72 | 0.00 | 3578.27 | 0.00 | 2381.45 |
| Sai, Allen, E,27781 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Romero, Gerald, K,19322 | 1565.43 | 0.00 | 0.00 | 1000.44 | 564.99 |
| Navarro, Beth,13534 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| Luo, Karla, V,11574 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Deng, Carly, E,22452 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Coleman, Trevor, C,25313 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Raji, Tracy,22439 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Huang, Jeffery,25755 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Alvarez, Ebony, M,28428 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Navarro, Micheal,23625 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Gutierrez, Jésus, E,16437 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Ms., Smith, Samantha,29407 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Ye, Dawn,25488 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2071.42 | 3090.31 |
| Lopez, Courtney,20839 | 2511.26 | 0.00 | 0.00 | 782.99 | 1728.27 |
| Patel, Emmanuel,14427 | 8451.26 | 0.00 | 3578.27 | 0.00 | 4872.99 |
| Wu, Heather, M,19261 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Deng, Leonard,27821 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Gill, Lori, A,22510 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Chen, Valerie,19911 | 3335.41 | 0.00 | 0.00 | 1000.44 | 2334.97 |
| Raje, Tony,24212 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Suri, Veronica, D,23967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2026-01-04 08:52:37.324 UTC