[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Serrano, Kristi,20616 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 28.98 | 49.99 |
| Arthur, Carla,16710 | 91.26 | 0.00 | 0.00 | 37.27 | 53.99 |
| Deng, Grant, C,16625 | 81.81 | 0.00 | 0.00 | 81.81 | 0.00 |
| Lu, Jamie, M,23646 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 2049.10 | 2304.98 | 2419.06 |
| Rubio, Max, L,19578 | 91.26 | 0.00 | 0.00 | 37.27 | 53.99 |
| Mehta, Michele,26143 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Chander, Andres, E,29460 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Carlson, Mathew, A,23012 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Li, Aimee,17915 | 4792.73 | 3578.27 | 0.00 | 0.00 | 1214.46 |
| Zeng, Suzanne,17918 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 59.98 | 143.48 |
| Jimenez, Neil,22151 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Lopez, Summer,12036 | 69.55 | 0.00 | 0.00 | 29.57 | 39.98 |
| Goel, Lacey, N,18704 | 33.26 | 0.00 | 0.00 | 30.97 | 2.29 |
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Mehta, Marco,11007 | 8211.00 | 3399.99 | 0.00 | 4811.01 | 0.00 |
| Zhao, Laura, T,24589 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Sanz, Linda, P,22945 | 12.94 | 0.00 | 0.00 | 12.94 | 0.00 |
| Diaz, Danny, C,18190 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Goel, Peter, L,15264 | 38.98 | 0.00 | 0.00 | 8.99 | 29.99 |
| Malhotra, Brett, E,18731 | 6054.06 | 0.00 | 3578.27 | 2475.79 | 0.00 |
| Miller, Edward,11368 | 5106.24 | 3374.99 | 0.00 | 0.00 | 1731.25 |
| Long, Mariah, C,16730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Edwards, Kaylee, M,22851 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 2071.42 | 0.00 | 4728.03 |
| Rodriguez, Toni, J,25251 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Davis, Isabella, A,22929 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
Generated 2026-07-22 18:56:23.468 UTC