[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 625 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raje, Dale, H,27746 | 628.97 | 0.00 | 0.00 | 628.97 | 0.00 |
| Johnson, Morgan, E,12011 | 4735.81 | 0.00 | 3374.99 | 618.47 | 742.35 |
| Liu, Jaclyn,12996 | 6808.15 | 0.00 | 0.00 | 2049.10 | 4759.05 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 6.28 | 56.76 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Romero, Sabrina, L,28534 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Subram, Kari,12682 | 227.96 | 0.00 | 0.00 | 0.00 | 227.96 |
| Shan, Thomas, N,27483 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Raman, Patricia, T,16702 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 2484.94 | 0.00 |
| Chow, Shannon,18444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Malhotra, Terrance, E,20223 | 187.38 | 0.00 | 0.00 | 0.00 | 187.38 |
| Andersen, Shawna, C,19556 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
| Zhou, Heather, M,24914 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Carlson, Kristy,28217 | 2408.29 | 0.00 | 0.00 | 2408.29 | 0.00 |
| Xu, Julie,18301 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Vazquez, Rebekah, A,15784 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Srini, Veronica,11996 | 7058.70 | 0.00 | 3374.99 | 1291.77 | 2391.94 |
| Gomez, Naomi, E,24300 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Long, Emily, L,26140 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Zheng, Darryl,18706 | 6060.50 | 0.00 | 3578.27 | 2482.23 | 0.00 |
| Gutierrez, Jaime, C,11457 | 8211.48 | 0.00 | 3374.99 | 2359.96 | 2476.53 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Ramos, Adrienne, L,28216 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Liang, Eugene,13972 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Ramos, Jay, D,21882 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Tang, Edwin,20450 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
Generated 2025-11-03 22:16:10.360 UTC