[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 249 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chander, Nichole, H,28451 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Ortega, Gary,11496 | 7013.79 | 0.00 | 3399.99 | 0.00 | 3613.80 |
| Subram, Jermaine,28731 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Kapoor, Heidi, D,17937 | 3068.82 | 0.00 | 0.00 | 2443.35 | 625.47 |
| Martin, Gloria, A,12325 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Ye, Dawn,25488 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Yuan, Shawn, P,27762 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Sanz, Juan, R,14983 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Navarro, Dwayne, H,11615 | 5205.71 | 0.00 | 0.00 | 2848.76 | 2356.95 |
| Rana, Tabitha, Y,16601 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Moreno, Kellie, T,16318 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Hernandez, Anne, B,11240 | 7586.23 | 0.00 | 3399.99 | 2369.96 | 1816.28 |
| Raje, Christine, W,17203 | 6952.53 | 0.00 | 0.00 | 2181.56 | 4770.97 |
| Ruiz, Ricky,20718 | 3283.43 | 0.00 | 0.00 | 782.99 | 2500.44 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Alonso, Kendra, C,16427 | 2975.02 | 0.00 | 0.00 | 2181.56 | 793.46 |
| Sara, Cory, A,21105 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Chande, Nina, D,19263 | 1587.41 | 0.00 | 0.00 | 1000.44 | 586.97 |
| Xu, Derek, M,20824 | 2512.96 | 0.00 | 0.00 | 2512.96 | 0.00 |
| Xu, Jenny, K,12222 | 6909.10 | 0.00 | 0.00 | 2049.10 | 4860.00 |
| Ross, Ryan,16428 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Goel, Kara,16465 | 3271.79 | 0.00 | 0.00 | 2443.35 | 828.44 |
| Goel, Shawn, L,19058 | 4524.48 | 0.00 | 0.00 | 2181.56 | 2342.92 |
| Sun, Alisha,18048 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Sara, Erick, M,25448 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Sai, Jermaine, G,14934 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
| Sai, Veronica,16509 | 3258.79 | 0.00 | 0.00 | 2443.35 | 815.44 |
Generated 2026-01-04 03:52:55.767 UTC