[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1032 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rana, Andre,27904 | 156.76 | 0.00 | 0.00 | 0.00 | 156.76 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
| Anderson, Cameron, L,16595 | 6901.38 | 0.00 | 0.00 | 2181.56 | 4719.82 |
| Garcia, Douglas,24860 | 2520.31 | 0.00 | 0.00 | 0.00 | 2520.31 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Jones, Andrew, C,16594 | 7231.37 | 0.00 | 0.00 | 2443.35 | 4788.02 |
| Sharma, Lacey, M,29472 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Lin, Lisa, A,17979 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| King, Adam, M,16932 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Munoz, Walter,21056 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| Arun, Andre, E,12287 | 5720.37 | 0.00 | 0.00 | 2049.10 | 3671.27 |
| Lin, Randy,14540 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Diaz, Armando, P,17978 | 3018.01 | 0.00 | 0.00 | 2181.56 | 836.45 |
| Li, Darryl, T,24549 | 2514.93 | 0.00 | 0.00 | 0.00 | 2514.93 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zeng, Aimee,19342 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Rubio, Victor, S,16193 | 90.47 | 0.00 | 0.00 | 0.00 | 90.47 |
| Guo, Christy, R,23639 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Fernandez, Heidi, L,22798 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Nath, Chad,17744 | 2765.53 | 0.00 | 0.00 | 2181.56 | 583.97 |
| Martin, Dalton, J,12505 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Gomez, Beth, C,13254 | 6801.13 | 0.00 | 0.00 | 2049.10 | 4752.03 |
| Brooks, Savannah, R,24558 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Ruiz, Pedro,24034 | 1203.46 | 0.00 | 0.00 | 0.00 | 1203.46 |
| Pal, Mohamed,20550 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Anand, Karla,17185 | 6954.57 | 0.00 | 0.00 | 2181.56 | 4773.01 |
Generated 2025-12-23 06:05:39.849 UTC