[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 250 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raje, Bridget, A,19433 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Rodriguez, Ann, S,12315 | 6803.13 | 0.00 | 0.00 | 4468.16 | 2334.97 |
| Torres, Hector, E,17700 | 2805.53 | 0.00 | 0.00 | 2805.53 | 0.00 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Andersen, Jaclyn,11468 | 6959.82 | 0.00 | 3374.99 | 2319.99 | 1264.84 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Rubio, Jamie, W,27179 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Srini, Ebony, A,17959 | 2748.83 | 0.00 | 0.00 | 2181.56 | 567.27 |
| Gonzalez, Bob, S,24569 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Kelly, Olivia, L,12391 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Henderson, Hunter, C,14812 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Lin, Franklin, M,24557 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Perry, Jose, M,12729 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Serrano, Sheila, C,21018 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Wu, Steve,14949 | 6795.60 | 0.00 | 3578.27 | 0.00 | 3217.33 |
| Deng, Karla, C,29382 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Black, Roger, J,28416 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Romero, Jerome,11337 | 8162.00 | 0.00 | 3374.99 | 2388.96 | 2398.05 |
| Wu, Roger,22630 | 1164.47 | 0.00 | 0.00 | 1164.47 | 0.00 |
| Tang, Kelvin,20832 | 2533.97 | 0.00 | 0.00 | 2533.97 | 0.00 |
| Tang, Nichole, C,15630 | 5136.37 | 0.00 | 3578.27 | 806.76 | 751.34 |
| Anand, Nichole,12508 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Hernandez, Renee, C,17803 | 2761.02 | 0.00 | 0.00 | 2181.56 | 579.46 |
| Patel, Denise,20179 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Garcia, Tammy, A,12293 | 86.76 | 0.00 | 0.00 | 0.00 | 86.76 |
| Rodriguez, Stefanie, L,12459 | 5618.54 | 0.00 | 0.00 | 2071.42 | 3547.12 |
| Romero, Lori, A,28738 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Lee, Emily,20585 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Nath, Nichole, K,12392 | 75.47 | 0.00 | 0.00 | 25.48 | 49.99 |
| Ruiz, Janet, M,22818 | 56.96 | 0.00 | 0.00 | 56.96 | 0.00 |
Generated 2025-12-21 22:37:10.902 UTC