[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 36 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Smith, Lucas, P,18090 | 64.91 | 0.00 | 0.00 | 0.00 | 64.91 |
| Price, Jocelyn, D,25875 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 0.00 | 846.77 |
| Evans, Luke,29176 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Zhao, Clarence, R,19826 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Baker, Ian, V,26200 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Richardson, Caitlin, T,23057 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| _SUM | 1806517.50 | 25543.71 | 496024.56 | 253394.87 | 1031554.36 |
| Smith, Chloe,17619 | 163.92 | 0.00 | 0.00 | 0.00 | 163.92 |
Generated 2025-12-21 02:45:02.263 UTC