[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 250 SHUFFLE SKIP 0 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Roberts, Thomas, J,21939 | 4163.24 | 0.00 | 3578.27 | 0.00 | 584.97 |
| Zhao, Clarence, R,19826 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Sandberg, Nicole, M,12077 | 144.69 | 0.00 | 0.00 | 89.47 | 55.22 |
| Washington, Christian, R,26686 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jackson, Andrew,20479 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Perez, Barry, M,27282 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Young, Kaitlyn, J,25062 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Jai, Hunter, M,28272 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Moore, Andrew, A,13944 | 150.13 | 0.00 | 0.00 | 0.00 | 150.13 |
| Rivera, Kaitlyn, R,15490 | 4813.52 | 0.00 | 0.00 | 0.00 | 4813.52 |
| Price, Caroline,18051 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ross, Kelly,26076 | 76.96 | 0.00 | 0.00 | 0.00 | 76.96 |
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
Generated 2025-12-24 05:52:02.492 UTC