[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE SKIP 0 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Williams, Sydney, J,15334 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Henderson, Austin,27643 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 72.26 | 794.55 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 292.94 | 862.58 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 86.48 | 912.74 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Robinson, Lauren,27196 | 68.49 | 0.00 | 0.00 | 68.49 | 0.00 |
| Mitchell, Savannah,26115 | 3052.80 | 0.00 | 0.00 | 2443.35 | 609.45 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 819.46 | 0.00 |
| Parker, Madeline, H,22182 | 6006.32 | 0.00 | 3578.27 | 0.00 | 2428.05 |
Generated 2025-11-04 13:59:47.301 UTC