[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhou, Jamie,17327 | 99.94 | 0.00 | 0.00 | 0.00 | 99.94 |
| Suarez, Linda,16665 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Prasad, George, C,15767 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Alvarez, Tanya,17279 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Goel, Brad, M,29085 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Lin, Dawn, N,15805 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Liang, Jenny, S,27351 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Guo, Sandra,23664 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Ramos, Gloria, A,21365 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Patel, Meredith,18333 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Fernandez, Marie,28929 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Navarro, Eddie, C,24504 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Zhu, Wesley, L,19624 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| James, Mariah, M,19104 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Luo, Casey,11072 | 8194.00 | 0.00 | 3399.99 | 2395.96 | 2398.05 |
| Townsend, Darren,18467 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Raje, Derek,12574 | 2626.39 | 0.00 | 2071.42 | 0.00 | 554.97 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Blanco, Lee, M,16660 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Patel, Deanna, H,27354 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Carlson, Audrey, A,25263 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Lal, Bradley,13156 | 2663.69 | 0.00 | 0.00 | 2071.42 | 592.27 |
| Raje, Darrell,20252 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Fernandez, Shane, A,13127 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Suarez, Lance, C,17230 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Wu, Christy, D,25568 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 0.00 | 539.99 |
| She, Sheena, R,23008 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 0.00 | 4679.06 |
| Lal, Mitchell, C,20403 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Deng, Latoya, H,21969 | 4759.47 | 0.00 | 0.00 | 2181.56 | 2577.91 |
| Carlson, Frank,11896 | 8117.97 | 0.00 | 3374.99 | 0.00 | 4742.98 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 0.00 | 66.75 |
| Sharma, Keith,15728 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Romero, Desiree, J,17239 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Madan, Cory,26154 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Nara, Tara,21194 | 3911.53 | 0.00 | 2181.56 | 0.00 | 1729.97 |
| Navarro, Francis, J,27520 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Rana, Johnathan, R,27497 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
Generated 2025-12-22 01:08:10.718 UTC