[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arun, Ruth, S,17294 | 4355.71 | 3578.27 | 0.00 | 0.00 | 777.44 |
| Sanz, Victor,17295 | 4392.74 | 3578.27 | 0.00 | 0.00 | 814.47 |
| Sharma, Terrence, N,17351 | 6117.69 | 3578.27 | 0.00 | 0.00 | 2539.42 |
| Green, Fernando,17258 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Goel, Nichole, A,17277 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Allen, Alexandra, B,17293 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Mehta, Nancy,18189 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| He, Aimee, A,11093 | 8180.00 | 0.00 | 3399.99 | 2360.95 | 2419.06 |
| Zhou, Cedric,17514 | 4142.23 | 0.00 | 3578.27 | 563.96 | 0.00 |
| Martin, Renee, L,17478 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Zeng, Micah, A,25561 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Schmidt, Shane,17922 | 4821.72 | 0.00 | 3578.27 | 0.00 | 1243.45 |
| Lal, Katie, E,18210 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Diaz, Ruben, A,25136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Raje, Colleen, M,19084 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Sharma, Tony,18241 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Cai, Tiffany,18204 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Lin, Autumn, E,18272 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Raje, Terrence,18246 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Zheng, Dennis, E,25567 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Yang, Heather,18275 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Ramos, Marc,18212 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Navarro, Kristine, B,25566 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Chande, Lindsay,18244 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Gomez, Felicia, J,18219 | 6038.56 | 0.00 | 3578.27 | 2460.29 | 0.00 |
| Moore, Natalie, W,18273 | 6104.21 | 0.00 | 3578.27 | 2525.94 | 0.00 |
| Sun, Alvin,18252 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Martinez, Bruce, D,18452 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Sun, Brittney,11365 | 5024.79 | 0.00 | 3374.99 | 0.00 | 1649.80 |
| Diaz, Aaron, C,18695 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Xu, Clayton,18488 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Serrano, Audrey,18337 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Yang, Jamie, S,18465 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Sharma, Dustin, M,18484 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Lopez, Savannah,25709 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Rubio, Robyn, A,18469 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Suri, Toni,18464 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Romero, Billy,20419 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kapoor, Regina,15810 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Ferrier, Linda, D,13149 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Patel, Janelle, T,29116 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Yuan, Darrell,18271 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Vazquez, Craig,28117 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Serrano, Darren,29196 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Zheng, Claudia,18691 | 6070.59 | 0.00 | 3578.27 | 2492.32 | 0.00 |
| Alvarez, Reginald, A,18746 | 6135.09 | 0.00 | 3578.27 | 2556.82 | 0.00 |
| Hill, Adam,18740 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 2430.96 | 2384.07 |
| Zhao, Micah,18708 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
| Ashe, Tara, J,19093 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
Generated 2025-11-03 13:09:54.614 UTC