[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 221 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 0.00 | 191.90 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Zhu, Suzanne, E,25112 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Carson, Bradley,23995 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 0.00 | 4704.06 |
| Rana, Meagan, M,11914 | 8165.96 | 0.00 | 3374.99 | 0.00 | 4790.97 |
| Navarro, Mathew, A,19673 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Sanchez, Olivia, J,14278 | 177.46 | 0.00 | 0.00 | 0.00 | 177.46 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Carlson, Philip, P,11915 | 8143.00 | 0.00 | 3374.99 | 0.00 | 4768.01 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vazquez, Rodney, M,13047 | 241.93 | 0.00 | 0.00 | 0.00 | 241.93 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 0.00 | 4712.32 |
| Raje, Gregory, C,22911 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Sanz, Ross,11455 | 8142.03 | 0.00 | 3374.99 | 2319.99 | 2447.05 |
| Lewis, Jasmine,13964 | 6806.45 | 0.00 | 0.00 | 2071.42 | 4735.03 |
| Gao, Jon, C,11456 | 8224.46 | 0.00 | 3399.99 | 2391.43 | 2433.04 |
| Ye, Lacey,29090 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Kapoor, Rachael, D,11911 | 62.46 | 0.00 | 0.00 | 0.00 | 62.46 |
| Andersen, Colin,25053 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Gao, Curtis, D,20429 | 5377.75 | 0.00 | 3578.27 | 0.00 | 1799.48 |
| Walker, Anthony, T,25250 | 1883.56 | 0.00 | 699.10 | 0.00 | 1184.46 |
| Serrano, Tyrone,11360 | 5025.80 | 0.00 | 3399.99 | 0.00 | 1625.81 |
| Rana, Marco, K,24473 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| He, Susan, A,24467 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
Generated 2026-01-04 05:27:30.000 UTC