[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 972 > < TAKE 14 >
14 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Mitchell, Sydney,29026 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
Wilson, Sarah, C,27098 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
Anand, Colin, G,27645 | 6051.31 | 3578.27 | 0.00 | 0.00 | 2473.04 |
Suarez, Krista,25468 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
Hughes, Elijah,25167 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
Long, Melanie, K,21503 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
Kumar, Thomas, M,12434 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
Robinson, Hunter, J,11155 | 2319.99 | 0.00 | 0.00 | 2319.99 | 0.00 |
Nara, Kate, L,25723 | 777.34 | 0.00 | 0.00 | 777.34 | 0.00 |
Ye, Cedric, K,19335 | 1957.47 | 0.00 | 0.00 | 1957.47 | 0.00 |
Campbell, Kaitlyn,21004 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
Hernandez, Savannah, F,16793 | 1788.95 | 0.00 | 0.00 | 1788.95 | 0.00 |
Diaz, David,11267 | 5943.23 | 0.00 | 3578.27 | 2364.96 | 0.00 |
Anderson, Miguel,19393 | 1134.47 | 0.00 | 0.00 | 1134.47 | 0.00 |
Generated 2024-09-21 11:29:22.705 UTC