[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Watson, Victoria,16125 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ramirez, Jennifer, E,21311 | 4472.58 | 0.00 | 0.00 | 2049.10 | 2423.48 |
| Roberts, Robert, R,18986 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Rogers, Sara,19874 | 4544.45 | 0.00 | 3374.99 | 0.00 | 1169.46 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| James, Julia,24975 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Sanchez, Trinity, J,26279 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Perry, Samuel,18811 | 100.96 | 0.00 | 0.00 | 0.00 | 100.96 |
| Thomas, Benjamin, J,21295 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Roberts, Thomas, J,21939 | 4163.24 | 0.00 | 3578.27 | 0.00 | 584.97 |
| Andersen, Latoya, J,29057 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Miller, Andrew, C,27110 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Deng, Wayne,21453 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Malhotra, Kristi, S,15175 | 4850.33 | 0.00 | 0.00 | 0.00 | 4850.33 |
| Brooks, Isaac, M,23385 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Barnes, Ian, M,16106 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Adams, Mackenzie, A,14640 | 812.42 | 0.00 | 0.00 | 0.00 | 812.42 |
| Mitchell, Caleb, K,26806 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Jacqueline,18391 | 100.96 | 0.00 | 0.00 | 0.00 | 100.96 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Parker, Katherine,13268 | 289.70 | 0.00 | 0.00 | 0.00 | 289.70 |
Generated 2025-12-22 08:28:55.838 UTC