[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 969 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanchez, George, M,12680 | 6880.10 | 0.00 | 0.00 | 2049.10 | 4831.00 |
| Williams, Anna, R,17504 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Jenkins, Wyatt,27987 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Dominguez, Jerome, F,22987 | 3942.03 | 0.00 | 0.00 | 2181.56 | 1760.47 |
| Vazquez, Anne,16027 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Rubio, Max, L,19578 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Alexander, Gail, C,14682 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Russell, Alexis, L,13634 | 234.93 | 0.00 | 0.00 | 0.00 | 234.93 |
| Navarro, Jaime, T,27690 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Suarez, Linda,16665 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Yang, Valerie, L,27361 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Becker, Latoya, W,17330 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Shan, Drew,23659 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Sara, Geoffrey,26188 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Malhotra, Marco, L,29459 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 2049.10 | 0.00 | 4742.00 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Patel, Abby,16029 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Zhang, Cara,12351 | 117.97 | 0.00 | 0.00 | 0.00 | 117.97 |
| Tang, Cristina, D,19623 | 153.93 | 0.00 | 0.00 | 0.00 | 153.93 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Navarro, Erik, E,25055 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martinez, Roy, J,13969 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Martin, Marc, J,11039 | 6636.58 | 3399.99 | 0.00 | 0.00 | 3236.59 |
| Raje, Derek,12574 | 2626.39 | 0.00 | 2071.42 | 0.00 | 554.97 |
| Gomez, Carrie,22965 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 0.00 | 2071.42 | 4730.03 |
| Ramos, Larry,18446 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sanz, Paula,26430 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Shan, Jenny, W,16706 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Nara, Dustin, M,17910 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Suri, Carmen, E,24250 | 2738.49 | 0.00 | 0.00 | 2181.56 | 556.93 |
| Gao, Louis,14666 | 5199.92 | 0.00 | 0.00 | 2049.10 | 3150.82 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 0.00 | 4789.02 |
| Chen, Bianca,24891 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2071.42 | 3052.32 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Weber, Cynthia,26921 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 0.00 | 4679.06 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Shan, Jaime,22020 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Schmidt, Kaitlin,13628 | 191.25 | 0.00 | 0.00 | 0.00 | 191.25 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Navarro, Monique, R,15240 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Blanco, Hector, J,22938 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
Generated 2025-12-22 00:31:52.288 UTC