[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 4739.30 | 0.00 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Fernandez, Manuel, A,16514 | 4761.74 | 3578.27 | 0.00 | 1183.47 | 0.00 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Liang, Martha,16525 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 1179.97 | 0.00 |
| Sai, Troy,16515 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 4849.00 | 0.00 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 2408.97 | 756.33 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 2520.83 | 0.00 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Alonso, Kristine,16686 | 4157.73 | 3578.27 | 0.00 | 0.00 | 579.46 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 928.49 | 0.00 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Dominguez, Robin,16685 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Moreno, Krista, J,16745 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Perez, Joel,16684 | 4158.24 | 3578.27 | 0.00 | 0.00 | 579.97 |
| Blanco, Lee, M,16660 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Lopez, Heidi,11052 | 8131.32 | 3374.99 | 0.00 | 4756.33 | 0.00 |
| Lee, Dalton, J,16931 | 4767.73 | 3578.27 | 0.00 | 1189.46 | 0.00 |
| Sanz, Kellie,16708 | 4406.74 | 3578.27 | 0.00 | 828.47 | 0.00 |
| Gutierrez, Natasha,17048 | 4382.75 | 3578.27 | 0.00 | 804.48 | 0.00 |
| Raman, Patricia, T,16702 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Xie, Cristina, C,17050 | 4496.23 | 3578.27 | 0.00 | 917.96 | 0.00 |
| King, Evan,16637 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Nath, Michele, L,11056 | 8207.50 | 3374.99 | 0.00 | 4832.51 | 0.00 |
| Raji, Tammy, K,17071 | 4417.75 | 3578.27 | 0.00 | 839.48 | 0.00 |
| Wang, Alejandro,17310 | 6029.57 | 3578.27 | 0.00 | 2451.30 | 0.00 |
| She, Willie,17055 | 4347.76 | 3578.27 | 0.00 | 769.49 | 0.00 |
| Watson, Maria,17229 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Goel, Carl, S,17249 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Kovar, Mayra, J,17312 | 4471.74 | 3578.27 | 0.00 | 0.00 | 893.47 |
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Green, Jonathan, A,17332 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 839.48 | 0.00 |
| Martin, Joan, R,25556 | 1253.07 | 699.10 | 0.00 | 0.00 | 553.97 |
| Raman, Michele,17233 | 4347.76 | 3578.27 | 0.00 | 769.49 | 0.00 |
| Alvarez, Tanya,17279 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Rubio, Randall, M,17286 | 6029.57 | 3578.27 | 0.00 | 2451.30 | 0.00 |
| Sanchez, Troy, H,25559 | 1253.07 | 699.10 | 0.00 | 0.00 | 553.97 |
| Li, Karen, K,17921 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Nara, Edwin, R,11097 | 8099.03 | 3374.99 | 0.00 | 2304.98 | 2419.06 |
| Mehta, Nancy,18189 | 4118.26 | 3578.27 | 0.00 | 539.99 | 0.00 |
| He, Aimee, A,11093 | 8180.00 | 3399.99 | 0.00 | 4780.01 | 0.00 |
| Diaz, Cheryl, A,11092 | 8110.02 | 3374.99 | 0.00 | 4735.03 | 0.00 |
| Sharma, Bonnie, R,25562 | 1239.09 | 699.10 | 0.00 | 0.00 | 539.99 |
| Vazquez, Kristine, M,17736 | 4742.74 | 3578.27 | 0.00 | 0.00 | 1164.47 |
WARNING: -TimestampIsOld-. Possible cause: API is currently initializing.
Generated 2026-07-23 03:05:27.619 UTC