[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Lin, Erica, E,16033 | 3743.39 | 0.00 | 2181.56 | 0.00 | 1561.83 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Martin, Billy, B,26849 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Williams, Jennifer, E,19457 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Arun, Heidi, Z,20149 | 3165.42 | 0.00 | 699.10 | 0.00 | 2466.32 |
| Ye, Randy, G,29367 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Lopez, Courtney,20839 | 2511.26 | 0.00 | 0.00 | 2511.26 | 0.00 |
| Raje, Melvin,11580 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Subram, Holly, J,28552 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Jimenez, Michele,13547 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Ms., Smith, Samantha,29407 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kapoor, Carolyn, M,16459 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Mitchell, Isaac,14554 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Jai, Shawna, W,17750 | 2888.53 | 0.00 | 0.00 | 2181.56 | 706.97 |
| Campbell, Andrea,25689 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rubio, Rebekah,24699 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Suri, Martin,16589 | 7343.69 | 0.00 | 0.00 | 2443.35 | 4900.34 |
| He, Cedric, W,25298 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vazquez, Meghan, W,15047 | 6669.57 | 0.00 | 3578.27 | 0.00 | 3091.30 |
| Chander, Jenny, A,19917 | 3369.41 | 0.00 | 0.00 | 1000.44 | 2368.97 |
| Baker, Mackenzie,16563 | 62.95 | 0.00 | 0.00 | 0.00 | 62.95 |
| Sanz, Kendra,17753 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| Wang, Dawn, L,27152 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sanchez, Morgan, J,12262 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
Generated 2025-12-21 01:18:48.200 UTC