[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 2188 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanz, Reginald, K,17522 | 74.95 | 0.00 | 0.00 | 0.00 | 74.95 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Becker, Kelli, E,16633 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Green, Sydney,23522 | 120.47 | 0.00 | 0.00 | 0.00 | 120.47 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Lu, Tiffany,22843 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Alvarez, Roy, A,16709 | 143.94 | 0.00 | 0.00 | 0.00 | 143.94 |
| Shen, Leonard, J,24271 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Sai, Abby, L,11101 | 8262.52 | 0.00 | 3399.99 | 2439.99 | 2422.54 |
| Zhang, Willie, T,16023 | 166.89 | 0.00 | 0.00 | 0.00 | 166.89 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Shan, Keith, T,20996 | 4149.99 | 0.00 | 3578.27 | 0.00 | 571.72 |
| Sai, Cesar,18243 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Liu, Suzanne,19594 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Raji, Carl,19595 | 6095.08 | 0.00 | 3578.27 | 0.00 | 2516.81 |
| Gomez, Alfredo, C,18200 | 4150.53 | 0.00 | 3578.27 | 0.00 | 572.26 |
| Huang, Brent,18220 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Sharma, Tony,18241 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Raji, Lindsey,18205 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Rai, Bradley,19100 | 79.26 | 0.00 | 0.00 | 0.00 | 79.26 |
| Ortega, Julio, M,11892 | 8119.03 | 0.00 | 3399.99 | 0.00 | 4719.04 |
| Lin, Margaret, C,18306 | 87.77 | 0.00 | 0.00 | 0.00 | 87.77 |
| Bhat, Yolanda,15225 | 4401.41 | 0.00 | 0.00 | 2071.42 | 2329.99 |
| Henderson, Marcus, D,15212 | 68.96 | 0.00 | 0.00 | 0.00 | 68.96 |
| Raman, Levi,29114 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Xu, Cedric,18198 | 4143.25 | 0.00 | 3578.27 | 0.00 | 564.98 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Chande, Lindsay,18244 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Gomez, Felicia, J,18219 | 6038.56 | 0.00 | 3578.27 | 2460.29 | 0.00 |
| Carson, Shaun,11126 | 4972.37 | 0.00 | 3399.99 | 0.00 | 1572.38 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| Sanz, Ricky,18251 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Henderson, Angela, T,11898 | 8179.03 | 0.00 | 3399.99 | 0.00 | 4779.04 |
| Sun, Brittney,11365 | 5024.79 | 0.00 | 3374.99 | 0.00 | 1649.80 |
| Gill, Diane,15578 | 4509.90 | 0.00 | 0.00 | 2071.42 | 2438.48 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 0.00 | 4748.04 |
| Chander, Alejandro, M,24455 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Zimmerman, Tiffany, E,23325 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Wu, Mandy,18309 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Sharma, Dustin, M,18484 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Moreno, Leslie, C,11114 | 122.89 | 0.00 | 0.00 | 0.00 | 122.89 |
| Townsend, Darren,18467 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Collins, Jennifer,11364 | 4921.82 | 0.00 | 3374.99 | 0.00 | 1546.83 |
| Zhao, Ernest, C,18700 | 5328.23 | 0.00 | 3578.27 | 1749.96 | 0.00 |
| Taylor, Jennifer,18470 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| McDonald, Kaitlin,18493 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Black, Peter, E,21213 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Suri, Toni,18464 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
Generated 2025-12-24 06:23:34.649 UTC