[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 5 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Fernandez, Geoffrey,19963 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Sharma, Andres, C,24230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Blanco, Erik, J,29093 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| She, Roger, L,15724 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 0.00 | 2520.83 |
| Lopez, Rachael,23425 | 3951.52 | 0.00 | 0.00 | 2181.56 | 1769.96 |
| Evans, Jackson,14321 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Luo, Casey,11072 | 8194.00 | 0.00 | 3399.99 | 2395.96 | 2398.05 |
| Liang, Gilbert,12242 | 3948.97 | 0.00 | 3374.99 | 0.00 | 573.98 |
| Perez, Kyle, J,16180 | 4386.37 | 0.00 | 0.00 | 2049.10 | 2337.27 |
| King, Mackenzie, M,26916 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Green, Alex, K,20317 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Patel, Janelle, T,29116 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Wang, Roger, P,24605 | 3627.81 | 0.00 | 0.00 | 3627.81 | 0.00 |
| Zeng, Micah, A,25561 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| Rai, Colleen,28933 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Pal, Donna, S,23572 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Ma, Jorge, O,14052 | 86.26 | 0.00 | 0.00 | 27.28 | 58.98 |
| Perry, Maria, N,17728 | 4730.03 | 0.00 | 3578.27 | 0.00 | 1151.76 |
| Ramos, Victor, D,24246 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Schmidt, Danny, M,28926 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
| Kumar, Cristina, N,15426 | 115.92 | 0.00 | 0.00 | 0.00 | 115.92 |
| Browning, Janet,19979 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Dominguez, Lee, R,24597 | 4009.50 | 0.00 | 0.00 | 2181.56 | 1827.94 |
| Diaz, Tyrone,13116 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Ramos, Kristine,17479 | 163.40 | 0.00 | 0.00 | 0.00 | 163.40 |
| Guo, Rosa, M,24474 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Gill, Jimmy,29098 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Zhu, Amy, W,26664 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Rubio, Robyn, A,18469 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Sharma, Tracy,17731 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Tang, April, A,25935 | 1256.03 | 0.00 | 699.10 | 0.00 | 556.93 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Gomez, Ricky,18737 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Dominguez, Joy,22175 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Malhotra, Emmanuel,18332 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Subram, Kristi, N,15025 | 128.94 | 0.00 | 0.00 | 0.00 | 128.94 |
| Hernandez, Orlando, C,21951 | 4923.29 | 0.00 | 0.00 | 2443.35 | 2479.94 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Zheng, Jenny, R,11947 | 4747.30 | 0.00 | 3374.99 | 629.96 | 742.35 |
| Gutierrez, Adrienne,18906 | 4217.22 | 0.00 | 3578.27 | 638.95 | 0.00 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
Generated 2025-12-24 05:58:36.255 UTC