[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 46 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Tang, Brad,25489 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Black, Willie,18172 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, April, E,25721 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Browning, Carrie, G,19299 | 1587.41 | 0.00 | 0.00 | 1000.44 | 586.97 |
| Zhu, Arturo, M,24575 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alvarez, Casey, A,28557 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Alvarez, Robin, V,11243 | 7164.25 | 0.00 | 3399.99 | 2364.98 | 1399.28 |
| Zhang, Trisha,18156 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Ortega, Carrie, L,11353 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Ruiz, Stacy,16823 | 7242.35 | 0.00 | 0.00 | 2443.35 | 4799.00 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Davis, Edward,28896 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Srini, Molly, L,27790 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Ashe, Melvin,26817 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Anand, Lindsey, K,22592 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Dominguez, Felicia, R,14196 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Chandra, Mayra,16453 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Sharma, Grant, R,23966 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gill, Clinton,26210 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Perez, Levi,26830 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Henderson, Marissa,13816 | 260.83 | 0.00 | 0.00 | 0.00 | 260.83 |
| Alexander, Isabel,22823 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Ma, Heather,17639 | 3075.03 | 0.00 | 0.00 | 2181.56 | 893.47 |
| Gonzalez, Arthur, G,28747 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Anand, Sharon,26208 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Townsend, Trinity, L,12367 | 160.45 | 0.00 | 0.00 | 0.00 | 160.45 |
| Ramos, Jill,21039 | 2483.98 | 0.00 | 0.00 | 2483.98 | 0.00 |
| Travers, Linda,29420 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Rogers, Melissa, J,28415 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
Generated 2025-12-23 11:38:47.619 UTC