[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1373 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nara, Latoya, J,18208 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Sun, Brittney,11365 | 5024.79 | 0.00 | 3374.99 | 0.00 | 1649.80 |
| Perez, Edgar, B,29318 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Goel, Misty, M,18245 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Goel, April, C,16166 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Diaz, Ricky, E,18335 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Carlson, Robin,19786 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Chapman, Preston, O,18268 | 6102.19 | 0.00 | 3578.27 | 0.00 | 2523.92 |
| Guo, Krystal, S,17381 | 188.93 | 0.00 | 0.00 | 0.00 | 188.93 |
| Nath, Tasha, J,18487 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Navarro, Kristine, B,25566 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Nara, Ricardo,28934 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Phillips, Jeremy, E,18495 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhu, Christy,11003 | 8139.29 | 3399.99 | 0.00 | 2318.96 | 2420.34 |
| Chande, Lindsay,18244 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Holt, Alisha,28350 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Townsend, Darren,18467 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Chen, Jaclyn, C,22847 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Martin, Larry,18254 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Huang, Vincent, A,18703 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ramos, Meredith, A,23307 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Sanchez, Joel,18468 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Hernandez, Ross,14677 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Sanz, Ricky,18251 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Ma, Omar, I,15232 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
Generated 2025-12-23 11:55:48.059 UTC