[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1094 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hayes, Alexia,25418 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Subram, Stanley, W,15925 | 5905.81 | 0.00 | 0.00 | 2443.35 | 3462.46 |
| Stewart, Cole, L,13595 | 9390.53 | 0.00 | 2181.56 | 0.00 | 7208.97 |
| Clark, Hannah, H,22055 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Alvarez, Andy,11329 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Suarez, Desiree, H,21061 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Rana, Carmen, A,14940 | 8367.55 | 0.00 | 3578.27 | 0.00 | 4789.28 |
| Perez, Cynthia, A,24536 | 586.97 | 0.00 | 0.00 | 0.00 | 586.97 |
| Wright, Alexandra, E,28995 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Patterson, Ryan, B,20791 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Gomez, Casey,22497 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Vazquez, Monique, A,23936 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Nelson, Mackenzie,20461 | 2492.32 | 0.00 | 0.00 | 0.00 | 2492.32 |
| Hernandez, Elijah,13903 | 4511.54 | 0.00 | 0.00 | 2181.56 | 2329.98 |
| Kapoor, Adriana,22705 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
Generated 2025-12-23 12:45:11.529 UTC