[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1500 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yuan, Maurice,24380 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alvarez, Marvin,23651 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Guo, Micah, M,24163 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Raman, Arthur,24001 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Zeng, Marshall, M,20987 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Hu, Susan,25242 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Nath, Tasha, J,18487 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Subram, Ann, M,18693 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Hill, Mackenzie,19576 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Nath, Latoya, A,27582 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Huang, Vincent, A,18703 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Liu, Omar, L,12252 | 3938.95 | 0.00 | 3374.99 | 0.00 | 563.96 |
| Yuan, Rafael, J,20625 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Zhang, Amy,18307 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| Edwards, Carlos,16680 | 104.86 | 0.00 | 0.00 | 0.00 | 104.86 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Lal, Carl, C,28950 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Diaz, Ricky, E,18335 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Gonzalez, Carla, J,18336 | 6145.07 | 0.00 | 3578.27 | 0.00 | 2566.80 |
| Weber, Chelsea,29191 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Griffin, Grace,11443 | 8235.00 | 0.00 | 3374.99 | 0.00 | 4860.01 |
| Madan, Francisco, S,25706 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Blanco, Cheryl,13524 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Xu, Julie,18301 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Lal, Kenneth, J,18701 | 5357.74 | 0.00 | 3578.27 | 1779.47 | 0.00 |
| Collins, Logan, H,13983 | 180.41 | 0.00 | 0.00 | 145.42 | 34.99 |
| Griffin, Blake, S,18699 | 5308.24 | 0.00 | 3578.27 | 1729.97 | 0.00 |
Generated 2025-11-03 20:54:10.037 UTC