[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 87 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzales, Haley,23071 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sr., Saraiva, José, E,14207 | 8361.30 | 0.00 | 3578.27 | 0.00 | 4783.03 |
| Anand, Omar,19375 | 120.46 | 0.00 | 0.00 | 0.00 | 120.46 |
| Deng, Nicolas, P,17738 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Lopez, Lydia,20142 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Xu, Autumn, I,12531 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Collins, Adam, A,14250 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Torres, Neil,17305 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Garcia, Bryant,11431 | 9912.98 | 0.00 | 3399.99 | 0.00 | 6512.99 |
| Ramos, Bruce,28475 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Smith, Seth, R,26786 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| McDonald, Elijah,18911 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Patterson, Mariah, F,26581 | 2822.76 | 0.00 | 0.00 | 2071.42 | 751.34 |
| Munoz, Paula, M,22066 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Bradley, Derrick,27322 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Hughes, Jordyn,24440 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
Generated 2025-12-24 05:59:09.944 UTC