[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 749 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Lindsey, R,22201 | 5012.27 | 0.00 | 0.00 | 2443.35 | 2568.92 |
| Ma, Rafael, T,13022 | 2644.02 | 0.00 | 0.00 | 2049.10 | 594.92 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Cai, Jeffery, A,15582 | 2907.56 | 0.00 | 0.00 | 2049.10 | 858.46 |
| Liang, Alejandro, W,29193 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Lee, Destiny,17058 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Jimenez, Victor,11461 | 8089.04 | 0.00 | 3374.99 | 0.00 | 4714.05 |
| Ortega, Max,23413 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Prasad, Marco, C,15606 | 115.93 | 0.00 | 0.00 | 0.00 | 115.93 |
| Moore, Thomas,14010 | 3861.39 | 0.00 | 0.00 | 2071.42 | 1789.97 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Martinez, Roy, J,13969 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Ms., Robinson, Rebecca, A.,11913 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Dominguez, Lee, R,24597 | 4009.50 | 0.00 | 0.00 | 2181.56 | 1827.94 |
| Pal, Dustin,26588 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Chande, Tonya,11992 | 8123.03 | 0.00 | 3399.99 | 0.00 | 4723.04 |
| Lu, Alan,19761 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Blanco, Lori, A,15735 | 116.25 | 0.00 | 0.00 | 0.00 | 116.25 |
| Garcia, Martin, l,23332 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| She, Ashlee,28319 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| King, Jesse, J,14665 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Martinez, Virginia,13136 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Navarro, Meredith,27703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nath, Tommy, B,28937 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rai, Terrence, R,25037 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Gao, Rafael, R,18733 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Raman, Ronald, M,17077 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Garcia, Chelsea,21961 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Sharma, Carl,21375 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-23 11:47:07.922 UTC