[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 986 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Powell, Seth,29157 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Patterson, Kaitlyn, R,12185 | 50.23 | 0.00 | 0.00 | 50.23 | 0.00 |
| Hernandez, Katelyn, L,11256 | 81.26 | 0.00 | 0.00 | 38.98 | 42.28 |
| Williams, Chloe, A,28106 | 12.94 | 0.00 | 0.00 | 12.94 | 0.00 |
| Howard, Jared, C,28053 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Roberts, Luis,27664 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Howard, Savannah, L,23839 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Suarez, Roberto, D,18128 | 85.48 | 0.00 | 0.00 | 85.48 | 0.00 |
| Sharma, Karla, A,24016 | 44.22 | 0.00 | 0.00 | 0.00 | 44.22 |
| Hu, Warren,23264 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Adams, Kaylee, F,17548 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Baker, Bailey,26271 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Xie, Maurice,15882 | 1372.46 | 0.00 | 0.00 | 1372.46 | 0.00 |
| Gray, Shelby, L,29145 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
Generated 2024-09-21 09:47:15.890 UTC