[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Simpson, Tara, K,28107 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| Dominguez, Andy, L,14126 | 135.55 | 0.00 | 0.00 | 0.00 | 135.55 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Jai, Ethan,15217 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Rana, Nancy, H,26150 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Kumar, Shawna, L,19085 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Chen, Claudia, R,16627 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Zhu, Tiffany,26437 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| Romero, Meredith, J,29452 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Walker, Anthony, T,25250 | 1883.56 | 699.10 | 0.00 | 0.00 | 1184.46 |
| Navarro, Renee,15793 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Shan, Mario,25271 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Martin, Reginald,14054 | 210.77 | 0.00 | 0.00 | 0.00 | 210.77 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Serrano, Tyrone,11360 | 5025.80 | 0.00 | 3399.99 | 0.00 | 1625.81 |
| Raman, Meagan, J,15134 | 5151.71 | 0.00 | 0.00 | 2071.42 | 3080.29 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Huang, Wesley,29320 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Tang, Nina,27485 | 1354.71 | 0.00 | 0.00 | 782.99 | 571.72 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Kumar, Tony, P,19783 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Tang, Sharon, M,15823 | 67.96 | 0.00 | 0.00 | 0.00 | 67.96 |
| Rubio, Larry,14223 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Shan, Tony, M,16175 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Zeng, Curtis, E,26669 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Andersen, Tara, L,24465 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Garcia, Rebekah, M,14007 | 3772.41 | 0.00 | 0.00 | 3772.41 | 0.00 |
| Black, Shaun, M,17355 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Diaz, Marc,11058 | 8248.02 | 0.00 | 3399.99 | 2374.98 | 2473.05 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Garcia, Andre, H,12705 | 6854.11 | 0.00 | 0.00 | 2049.10 | 4805.01 |
| Tang, Cristina, D,19623 | 153.93 | 0.00 | 0.00 | 0.00 | 153.93 |
| Blanco, Sheila, I,17724 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Harris, Ian, W,14128 | 3836.38 | 0.00 | 0.00 | 2071.42 | 1764.96 |
| Malhotra, Toni,26162 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Zhao, Jaclyn, D,26167 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Muñoz, Pedro, A,23433 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Pal, Terry, H,25824 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Ramos, Stacy, D,18261 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Moyer, Meghan,21220 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Raje, Lindsey,24614 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Raje, Alison, J,12345 | 64.71 | 0.00 | 0.00 | 0.00 | 64.71 |
Generated 2025-12-21 19:49:54.194 UTC