[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 953 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Malhotra, Douglas, L,22960 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Jacquelyn, P,27464 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Wang, Laura, L,26146 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Andersen, Nina,18338 | 6124.58 | 0.00 | 3578.27 | 0.00 | 2546.31 |
| Goldstein, Brendan,13518 | 2638.36 | 0.00 | 0.00 | 2049.10 | 589.26 |
| Zhao, Heather,24596 | 4168.83 | 0.00 | 0.00 | 2443.35 | 1725.48 |
| Deng, Kenneth,20235 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Gao, Laura,22029 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Huang, Margaret, H,17070 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Liu, Karen, F,14008 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Zhou, Arturo, F,27910 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Luo, Raul, Q,20154 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Smith, Andre,21174 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 0.00 | 2049.10 | 4742.00 |
| Garcia, Ruben,19613 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Chander, Devon,24612 | 2152.20 | 0.00 | 0.00 | 1000.44 | 1151.76 |
| Kumar, Tony, P,19783 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Sharma, Donna,11998 | 6962.10 | 0.00 | 3374.99 | 0.00 | 3587.11 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Carlson, Lawrence, L,22064 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Huang, Amy, C,12244 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Sanz, Francis,12577 | 2614.08 | 0.00 | 0.00 | 2049.10 | 564.98 |
| Ye, Marshall, R,26559 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gonzalez, Rebekah, A,16927 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Gonzalez, Meredith,22171 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Ramos, Roy, A,24482 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Pal, Mindy,19097 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Hu, Crystal,27980 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Nath, Louis, C,25830 | 1833.57 | 0.00 | 699.10 | 0.00 | 1134.47 |
Generated 2025-12-23 11:57:10.195 UTC