[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Bailey, Richard, N,22050 | 4160.53 | 3578.27 | 0.00 | 0.00 | 582.26 |
| Mitchell, Lucas, C,19829 | 4533.45 | 3374.99 | 0.00 | 0.00 | 1158.46 |
| Mitchell, Jonathan, L,22109 | 5971.33 | 3578.27 | 0.00 | 2393.06 | 0.00 |
| Murphy, Emma,19844 | 5807.93 | 3374.99 | 0.00 | 0.00 | 2432.94 |
| Smith, John,19855 | 5709.96 | 0.00 | 3399.99 | 0.00 | 2309.97 |
| Parker, Madeline, H,22182 | 6006.32 | 0.00 | 3578.27 | 0.00 | 2428.05 |
| Miller, Benjamin, G,26643 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Turner, Sean,22732 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Murphy, Richard, M,22299 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Perry, Oscar,22785 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Collins, Luis, J,22765 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
| Howard, Morgan, T,22971 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Miller, Chloe, V,22893 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
Generated 2024-09-20 04:29:36.996 UTC