[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yuan, Derek, L,27589 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Lin, Clayton, M,27492 | 1344.91 | 0.00 | 0.00 | 782.99 | 561.92 |
| Guo, Cedric, R,27487 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Cox, Isaac,15797 | 4415.68 | 0.00 | 0.00 | 2071.42 | 2344.26 |
| Munoz, Sheila,27488 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Shan, Thomas, N,27483 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Sun, Jorge,16025 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Allen, Ian, A,16031 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Munoz, Natasha, M,24601 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Zhao, Heather,24596 | 4168.83 | 0.00 | 0.00 | 2443.35 | 1725.48 |
| Gomez, Kathleen, J,16158 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Dominguez, Lee, R,24597 | 4009.50 | 0.00 | 0.00 | 2181.56 | 1827.94 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| He, Susan, A,24467 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
Generated 2025-12-24 05:53:39.875 UTC