[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 190 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rodriguez, Douglas, W,19652 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Anand, Niñia, L,19949 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| Blanco, Rodney, A,20158 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Dominguez, Gina, L,20213 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Ms., Robinson, Dorothy, B.,11952 | 8169.00 | 0.00 | 3374.99 | 0.00 | 4794.01 |
| Zheng, Jaclyn, F,11910 | 8113.03 | 0.00 | 3374.99 | 0.00 | 4738.04 |
| Gomez, Adrienne,11920 | 8156.32 | 0.00 | 3374.99 | 0.00 | 4781.33 |
| Liu, Trisha, V,20214 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Huang, Dawn, E,11943 | 4734.29 | 0.00 | 3374.99 | 539.99 | 819.31 |
| Fernandez, George,19974 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Xu, Randy, S,11969 | 8173.02 | 0.00 | 3399.99 | 0.00 | 4773.03 |
| Browning, Janet,19979 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Zhang, Louis, K,20227 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Lal, Barbara, W,23101 | 2795.01 | 0.00 | 0.00 | 2181.56 | 613.45 |
| Malhotra, Geoffrey, W,18298 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 0.00 | 46.75 |
| Hill, Noah,26192 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Zhang, Aimee,26025 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Suri, Jillian, L,15180 | 4466.39 | 0.00 | 0.00 | 2071.42 | 2394.97 |
| Pal, Clayton,27721 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Ma, Warren, A,19762 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Gomez, Armando, S,21175 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Xu, Arturo,13619 | 6808.10 | 0.00 | 0.00 | 2049.10 | 4759.00 |
| Pal, Drew,11902 | 63.04 | 0.00 | 0.00 | 0.00 | 63.04 |
| Raje, Rafael, M,13000 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Goel, Gilbert,15596 | 4460.04 | 0.00 | 0.00 | 2049.10 | 2410.94 |
Generated 2026-01-04 05:26:07.638 UTC