[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 993 > < TAKE 14 >
14 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
James, Maria,16243 | 91.97 | 0.00 | 0.00 | 69.99 | 21.98 |
Price, Jacqueline, R,11194 | 105.75 | 0.00 | 0.00 | 42.28 | 63.47 |
Wood, Morgan, M,18760 | 54.98 | 0.00 | 0.00 | 54.98 | 0.00 |
Zeng, Leah,27390 | 47.96 | 0.00 | 0.00 | 0.00 | 47.96 |
Wang, Lacey,24173 | 2771.52 | 0.00 | 0.00 | 2181.56 | 589.96 |
Chandra, Brandy, P,11501 | 872.25 | 0.00 | 0.00 | 128.21 | 744.04 |
Sanz, Francis,12577 | 2614.08 | 0.00 | 2049.10 | 0.00 | 564.98 |
Peterson, Patrick, J,16748 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
Jai, Kurt, L,12723 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
Mehta, Manuel,25302 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
Lal, Adam,13877 | 3030.03 | 0.00 | 0.00 | 3030.03 | 0.00 |
Munoz, Kellie,25740 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
Butler, Eduardo, G,13533 | 137.94 | 0.00 | 0.00 | 68.97 | 68.97 |
Kelly, Garrett, S,12069 | 5897.53 | 0.00 | 3578.27 | 2319.26 | 0.00 |
Generated 2024-09-21 05:30:23.099 UTC