[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 972 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Gonzales, Abigail,20333 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Clark, Ryan, S,17164 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Perez, Bobby, D,26875 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Kumar, Wayne,17502 | 6070.59 | 3578.27 | 0.00 | 0.00 | 2492.32 |
| Thomas, Jacob, C,19991 | 596.96 | 0.00 | 0.00 | 0.00 | 596.96 |
| Carlson, Jaime, J,17470 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Alexander, Julia, J,15291 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| James, Brianna,17010 | 2384.97 | 0.00 | 0.00 | 0.00 | 2384.97 |
| Harris, Benjamin,17363 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Mehta, Ruth,15702 | 6917.54 | 0.00 | 2181.56 | 0.00 | 4735.98 |
| Sharma, Jordan, R,17393 | 2404.91 | 0.00 | 0.00 | 0.00 | 2404.91 |
| Alexander, Jason,29328 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Rogers, Isaiah, W,29235 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Price, Marissa,15826 | 184.71 | 0.00 | 0.00 | 120.48 | 64.23 |
Generated 2024-09-21 09:59:09.298 UTC