[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 1000 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| Long, Mariah, C,16730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Rodriguez, Toni, J,25251 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Serrano, Audrey,18337 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Romero, Philip, F,22195 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 2443.35 | 0.00 | 2482.23 |
| Li, David, A,21894 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Rubio, Philip, P,21876 | 4663.38 | 0.00 | 2181.56 | 0.00 | 2481.82 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 0.00 | 782.99 | 1233.96 |
| Huang, Valerie, J,26745 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Rai, Nina,14018 | 63.87 | 0.00 | 0.00 | 0.00 | 63.87 |
| Blanco, Brandi, L,20986 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zhou, Brent,15434 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Thompson, Cameron, M,16620 | 5895.24 | 3578.27 | 0.00 | 0.00 | 2316.97 |
| Martinez, Cory, A,15125 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Zheng, Alisha,22203 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Allen, Ian, A,16031 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Williams, Anna, R,17504 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Torres, Michele, A,16176 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Prasad, Jarrod,11359 | 4960.07 | 0.00 | 3374.99 | 0.00 | 1585.08 |
| Serrano, Natasha,25563 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Xu, Tasha, E,11948 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Gutierrez, Tabitha, A,21884 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| She, Jeffery, M,27149 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Jai, Calvin, S,22918 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Guo, Cara, R,15721 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Jenkins, Wyatt,27987 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Wang, Nathan,14039 | 6808.13 | 0.00 | 0.00 | 2049.10 | 4759.03 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Navarro, Lori,21182 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Malhotra, Heidi, A,26426 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lu, Valerie,22913 | 4684.39 | 0.00 | 0.00 | 2181.56 | 2502.83 |
| Dominguez, Jerome, F,22987 | 3942.03 | 0.00 | 0.00 | 2181.56 | 1760.47 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Romero, Clinton, F,28132 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 0.00 | 173.93 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 28.98 | 32.60 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 34.89 | 94.46 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 59.48 | 31.27 |
| Goel, Alicia, H,20423 | 4177.74 | 0.00 | 3578.27 | 599.47 | 0.00 |
| Jai, Rafael, L,17323 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Ye, Willie,22963 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Lu, Darryl,27702 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Diaz, Kendra,13021 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Alvarez, Pedro, E,28120 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Black, Tommy,24376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Arun, Levi, A,11074 | 94.19 | 0.00 | 0.00 | 49.97 | 44.22 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 3302.05 | 0.00 |
| Luo, Colin, L,21210 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
Generated 2025-11-06 19:43:53.352 UTC