[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 243 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chande, Tracy, J,12588 | 2639.08 | 0.00 | 2049.10 | 0.00 | 589.98 |
| Subram, Evelyn, S,21257 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Wood, Maria,12667 | 6813.12 | 0.00 | 2049.10 | 0.00 | 4764.02 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
| Hernandez, Kellie, A,12586 | 2636.41 | 0.00 | 2071.42 | 0.00 | 564.99 |
| Serrano, Alfredo,21258 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Jai, Michele, E,21225 | 4732.86 | 0.00 | 2181.56 | 0.00 | 2551.30 |
| Rodriguez, Carla, V,21230 | 4171.62 | 0.00 | 2443.35 | 0.00 | 1728.27 |
| Cai, Curtis,21259 | 3907.54 | 0.00 | 2181.56 | 0.00 | 1725.98 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 2071.42 | 0.00 | 4741.35 |
| Zhang, Jenny, H,24609 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Chander, Devon,24612 | 2152.20 | 0.00 | 1000.44 | 1151.76 | 0.00 |
Generated 2025-11-06 08:58:40.402 UTC