[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 64 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 0.00 | 1228.83 |
| Howard, Erin, L,18362 | 1725.21 | 0.00 | 0.00 | 0.00 | 1725.21 |
| Harris, Samuel, M,24771 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Johnson, Jacob, I,28069 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Nelson, Jennifer,17147 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Robinson, William,20103 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Perry, Dalton, A,16149 | 192.04 | 0.00 | 0.00 | 0.00 | 192.04 |
| Powell, David, W,26615 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Serrano, Albert, E,13328 | 4708.02 | 0.00 | 0.00 | 0.00 | 4708.02 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 0.00 | 196.27 |
| Murphy, Shelby,24489 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-21 16:11:15.669 UTC