[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2405 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jones, Devin, H,27742 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gonzalez, Julia, W,16413 | 37.93 | 0.00 | 0.00 | 0.00 | 37.93 |
| Patterson, Brianna, B,27410 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Rivera, Jade,17139 | 2309.97 | 0.00 | 0.00 | 0.00 | 2309.97 |
| Dominguez, Desiree, S,11427 | 9917.99 | 0.00 | 3399.99 | 0.00 | 6518.00 |
| Coleman, Hannah, L,21320 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| Morris, Sara,19984 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Russell, Kelly, E,19981 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Jai, Elijah,23443 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Parker, Allison,26501 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Bailey, Isaiah, H,17751 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Sharma, Jose, R,13244 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Price, Eduardo, W,22761 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Martin, Stacy, D,14803 | 4355.71 | 0.00 | 3578.27 | 0.00 | 777.44 |
| Alvarez, Alberto,23358 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
Generated 2025-12-17 23:15:47.424 UTC