[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 63 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lewis, Katherine,14816 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Alonso, Arthur, M,19054 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Gao, Lacey, C,16531 | 3291.80 | 0.00 | 0.00 | 2443.35 | 848.45 |
| Nara, Shawn, C,13845 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Sun, Rosa,26900 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Reed, Cole,12603 | 117.45 | 0.00 | 0.00 | 0.00 | 117.45 |
| Pal, Jon, H,15440 | 6736.56 | 0.00 | 3578.27 | 0.00 | 3158.29 |
| Nara, Jaime, D,13262 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Rowe, Kristi, R,28692 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sai, Marco,24840 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Richardson, Megan, M,15662 | 5253.07 | 0.00 | 3578.27 | 0.00 | 1674.80 |
| Wood, Julian, A,18166 | 7200.37 | 0.00 | 0.00 | 2443.35 | 4757.02 |
| Evans, Hunter,25493 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Jordan, Terrance, B,16546 | 3036.53 | 0.00 | 0.00 | 2181.56 | 854.97 |
| Patel, Patricia,20569 | 3114.06 | 0.00 | 699.10 | 0.00 | 2414.96 |
| Madan, Frederick,16550 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Munoz, Meghan, P,27810 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Luo, Bonnie,19337 | 1575.42 | 0.00 | 0.00 | 1000.44 | 574.98 |
| Liu, Jamie, J,19301 | 1590.42 | 0.00 | 0.00 | 1000.44 | 589.98 |
| Chandra, Deanna,18141 | 6972.86 | 0.00 | 0.00 | 2181.56 | 4791.30 |
| Kumar, Maurice, L,22600 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Tang, Casey,15046 | 5943.25 | 0.00 | 3578.27 | 0.00 | 2364.98 |
| Guo, Dawn, R,25603 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Hu, Sandra, N,27817 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Suarez, Sheila,28884 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| Navarro, Armando,19942 | 3034.07 | 699.10 | 0.00 | 0.00 | 2334.97 |
| Lal, Tony,28515 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| She, Karla, T,12215 | 6890.73 | 0.00 | 0.00 | 2071.42 | 4819.31 |
| Lopez, Michele, C,21509 | 3117.96 | 0.00 | 0.00 | 782.99 | 2334.97 |
| Lin, Lisa, A,17979 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Becker, Karla, M,12730 | 64.90 | 0.00 | 0.00 | 0.00 | 64.90 |
Generated 2025-12-24 06:34:47.284 UTC