[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 36 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wang, Margaret, P,22815 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Russell, Lauren, T,23130 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Prasad, Adriana, W,20050 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Simmons, Benjamin, I,14625 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Torres, Sean,23669 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Xu, Gregory,25803 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Lopez, Cynthia, D,28846 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 |
| Smith, Alexis, L,26725 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Rodriguez, Emmanuel, A,28768 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Liang, Colleen, Q,17740 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hall, Devin,27204 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Thomas,22338 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Moore, David, A,23054 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Walker, Matthew,29371 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
Generated 2025-12-22 06:44:06.355 UTC