[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Hall, Destiny, G,25615 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 0.00 | 57.95 |
| Lal, Alvin,24058 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Shan, Cedric, H,23775 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Zhang, Benjamin, F,12593 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Patel, Stefanie,27967 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Howard, Makayla,16251 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Travers, Jill, A,16602 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| She, Clayton,13785 | 121.83 | 0.00 | 0.00 | 0.00 | 121.83 |
| Holt, Dale, C,23618 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alonso, Felicia, A,26842 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Walker, Madison,17105 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| She, Kelvin, T,27002 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Shan, Alicia,27964 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zhang, Candice, J,23777 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Gutierrez, Kathleen,17786 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanz, Juan, R,14983 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Townsend, Trinity, L,12367 | 160.45 | 0.00 | 0.00 | 0.00 | 160.45 |
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Munoz, Lori, M,22639 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Baker, Mackenzie,16563 | 62.95 | 0.00 | 0.00 | 0.00 | 62.95 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-22 02:32:31.667 UTC