[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 405 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Alvarez, Lori, C,26662 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 2071.42 | 3581.10 |
| Jiménez, Bruce, L,23640 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Garcia, Rebekah, M,14007 | 3772.41 | 0.00 | 0.00 | 3772.41 | 0.00 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 2071.42 | 1764.96 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 2049.10 | 3616.79 |
| Muñoz, Pedro, A,23433 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Jimenez, Melody, S,14066 | 3612.19 | 0.00 | 0.00 | 2853.57 | 758.62 |
| Alonso, Casey, E,23422 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Lopez, Donald, A,26740 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Kumar, Warren, A,24003 | 2806.53 | 0.00 | 0.00 | 2181.56 | 624.97 |
| Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
Generated 2025-12-21 23:16:53.262 UTC