[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 250 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Romero, Dwayne,28314 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Moreno, Felicia, A,12987 | 6759.47 | 0.00 | 0.00 | 2071.42 | 4688.05 |
| He, Curtis, D,24921 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 34.89 | 45.22 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 7.95 | 34.98 |
| Liang, Rosa, L,19770 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Carlson, Armando,17484 | 126.96 | 0.00 | 0.00 | 21.98 | 104.98 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 132.95 | 0.00 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 2294.99 | 2393.06 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 21.98 | 68.97 |
| Sun, Karen, C,28208 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Jai, Latoya, S,21229 | 4198.33 | 0.00 | 2443.35 | 0.00 | 1754.98 |
| Madan, Brenda,13043 | 175.93 | 0.00 | 0.00 | 0.00 | 175.93 |
| Shen, Wayne, P,23647 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Pal, Mindy,19097 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Madan, Cory,26154 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Nath, Louis, C,25830 | 1833.57 | 0.00 | 699.10 | 0.00 | 1134.47 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 0.00 | 4714.05 |
| Sanz, Orlando,14309 | 99.47 | 0.00 | 0.00 | 74.48 | 24.99 |
| Xie, Marshall, M,19796 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Smith, Adriana,18702 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Cox, Jared, E,28114 | 570.47 | 0.00 | 0.00 | 570.47 | 0.00 |
| Madan, Jay, L,20156 | 4139.75 | 0.00 | 3578.27 | 561.48 | 0.00 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 2433.04 | 0.00 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 2484.94 | 0.00 |
| Zeng, Heather, E,18287 | 72.16 | 0.00 | 0.00 | 72.16 | 0.00 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Martin, Roy,22065 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Prasad, Denise,18294 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
Generated 2025-11-07 00:03:12.085 UTC