[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SKIP 500 < SKIP 1000 > < TAKE 1000
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gray, Jared, A,26449 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Henderson, Justin, P,23591 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| White, Greg, C,17403 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| _SUM | 1806517.50 | 68775.49 | 486282.13 | 325039.81 | 926420.07 |
Generated 2025-11-02 00:35:42.428 UTC