[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 375 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sara, Cory, A,21105 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Chapman, Bob, W,21134 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gutierrez, Walter,25141 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Ruben, J,25304 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Zeng, Todd, C,12283 | 5582.91 | 0.00 | 0.00 | 3272.94 | 2309.97 |
| Tang, Alejandro, L,11542 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Xu, Katie, R,14799 | 162.95 | 0.00 | 0.00 | 0.00 | 162.95 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Madan, Carolyn,26222 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Nara, Louis, J,26901 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Rubio, Jamie, W,27179 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Nath, Leonard, L,12637 | 6845.12 | 0.00 | 0.00 | 2049.10 | 4796.02 |
| Ramos, Alberto,12239 | 6901.42 | 0.00 | 0.00 | 2071.42 | 4830.00 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lal, Alvin,24058 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Garcia, Meredith,17110 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Andersen, Leonard,17772 | 2846.00 | 0.00 | 0.00 | 2181.56 | 664.44 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raman, Martin,17709 | 78.95 | 0.00 | 0.00 | 0.00 | 78.95 |
| Raji, Tara,12385 | 5118.75 | 0.00 | 0.00 | 2071.42 | 3047.33 |
| Romero, Mathew, L,16043 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Hu, Louis,16187 | 34.92 | 0.00 | 0.00 | 0.00 | 34.92 |
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 0.00 | 62.76 |
| Bradley, Isabel,27783 | 165.28 | 0.00 | 0.00 | 0.00 | 165.28 |
| Nath, Sheena,25800 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Nara, April, E,25721 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Ruiz, Audrey,12645 | 6847.76 | 0.00 | 0.00 | 2071.42 | 4776.34 |
Generated 2025-12-24 06:34:51.558 UTC