[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 219 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Navarro, Arthur,16198 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Srini, Whitney,11560 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Ortega, Walter,28377 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Griffin, Jeremiah,18158 | 6869.61 | 0.00 | 0.00 | 2181.56 | 4688.05 |
| He, Cedric, W,25298 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Alexandria, R,11555 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Andersen, April, C,20973 | 193.98 | 0.00 | 0.00 | 0.00 | 193.98 |
| Jai, Kate,14706 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sanchez, Heidi,28438 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lu, Bianca,13252 | 6820.46 | 0.00 | 0.00 | 2071.42 | 4749.04 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Gao, Jessie,20564 | 3059.08 | 0.00 | 699.10 | 0.00 | 2359.98 |
| Shen, Carl, L,19190 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Roberts, Nathan,29470 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gill, Julio, R,26993 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ruiz, Briana,20906 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Romero, Mathew, L,16043 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Luo, Leonard, A,25582 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Ms., Li, Amy, J,12592 | 51.96 | 0.00 | 0.00 | 0.00 | 51.96 |
| Black, Tara,24216 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Diaz, Armando, P,17978 | 3018.01 | 0.00 | 0.00 | 2181.56 | 836.45 |
| Suarez, Reginald,18177 | 7043.56 | 0.00 | 0.00 | 2181.56 | 4862.00 |
| Sai, Roy, J,16038 | 84.25 | 0.00 | 0.00 | 0.00 | 84.25 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Serrano, Larry,21516 | 3102.25 | 0.00 | 0.00 | 782.99 | 2319.26 |
Generated 2025-12-22 00:29:59.582 UTC