[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 7 >
7 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Ortega, Meghan, E,22004 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
Raje, Mario, S,20427 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
Suri, Michele,18007 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
Bailey, Kaitlyn, M,12153 | 5938.23 | 0.00 | 3578.27 | 2359.96 | 0.00 |
Edwards, Jose, W,12078 | 5975.23 | 0.00 | 3578.27 | 0.00 | 2396.96 |
Smith, Alyssa,26083 | 5794.05 | 0.00 | 3374.99 | 0.00 | 2419.06 |
Perry, Isabella, A,14475 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
Generated 2024-09-21 00:32:28.704 UTC