[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 1000 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Goel, Shawna, L,29332 | 165.28 | 0.00 | 0.00 | 165.28 | 0.00 |
| Fernandez, Marie,28929 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ashe, Orlando, I,11897 | 8203.02 | 0.00 | 3399.99 | 0.00 | 4803.03 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Romero, Lance,18310 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rivera, Jada,21970 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 1000.44 | 1147.77 | 0.00 |
| Alonso, Ricky, S,14070 | 5618.93 | 0.00 | 0.00 | 2049.10 | 3569.83 |
| Butler, Austin, W,18293 | 74.24 | 0.00 | 0.00 | 74.24 | 0.00 |
| Nara, Dale, L,21226 | 4659.80 | 0.00 | 2181.56 | 0.00 | 2478.24 |
| Zhang, Clarence, M,13001 | 6799.43 | 0.00 | 0.00 | 2049.10 | 4750.33 |
| Johnsen, Jerry,26670 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Jai, Tara, E,27363 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Black, Priscilla,15766 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Hernandez, Ross,14677 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
Generated 2025-11-06 15:33:14.559 UTC