[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 47 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Alisha,24534 | 2533.93 | 0.00 | 0.00 | 0.00 | 2533.93 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Chander, Casey, C,16554 | 2990.52 | 0.00 | 0.00 | 2181.56 | 808.96 |
| Diaz, Reginald, A,24581 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhang, Margaret, G,16058 | 38.25 | 0.00 | 0.00 | 0.00 | 38.25 |
| Alvarez, Julio,26205 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Patterson, Jessica,17182 | 6950.60 | 0.00 | 0.00 | 2181.56 | 4769.04 |
| Ruiz, Theodore,20052 | 3214.03 | 0.00 | 699.10 | 0.00 | 2514.93 |
| Lal, Ricardo, C,17958 | 2811.52 | 0.00 | 0.00 | 2181.56 | 629.96 |
| Andersen, Kelli,22602 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Ms., Smith, Samantha,29407 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Moreno, Gary, E,21544 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Rivera, Chase,28511 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Moreno, Kari, S,15052 | 44.57 | 0.00 | 0.00 | 0.00 | 44.57 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Young, Evan,12739 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Bryant, Noah,16417 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Lopez, Allen, O,13821 | 5940.54 | 0.00 | 3578.27 | 0.00 | 2362.27 |
| Mr., Sneath, Timothy,17708 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Watson, Ian, G,26398 | 1758.95 | 0.00 | 0.00 | 0.00 | 1758.95 |
| Yang, Ryan,28723 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Yuan, Shawn, P,27762 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Navarro, Gary, E,13561 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Nara, Casey, E,17812 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| Moreno, Lee,25632 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Gomez, Theodore,13503 | 101.25 | 0.00 | 0.00 | 0.00 | 101.25 |
| Chander, Christy, E,21548 | 36.93 | 0.00 | 0.00 | 0.00 | 36.93 |
Generated 2025-12-23 05:59:18.690 UTC