[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 83 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Ma, Laura, L,24503 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Vazquez, Daisy, L,25560 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Madan, Candace,22409 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Johnson, Brianna, J,17319 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ramos, Dana, D,25919 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Zeng, Dawn, D,29455 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Carlson, Clinton, E,11116 | 148.70 | 0.00 | 0.00 | 0.00 | 148.70 |
| Gill, Jaime, M,26152 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Rubio, Deanna, T,19573 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Liang, Damien, M,22150 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Bailey, Sean, L,27710 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
Generated 2025-12-22 03:18:25.623 UTC