[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 65 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xylaras, Ioannis,20215 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Li, Alvin,26764 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Schmidt, Deanna, H,25936 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Alvarez, Lori, C,26662 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Zhang, Claudia,13114 | 6807.45 | 0.00 | 0.00 | 2071.42 | 4736.03 |
| She, Corey, T,21214 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Vazquez, Jésus,26665 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Travers, Reginald,28488 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Cook, Faith,27871 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Suarez, Tabitha,25110 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Perez, Brett, M,28313 | 647.94 | 0.00 | 0.00 | 0.00 | 647.94 |
| Kapoor, Veronica, G,20253 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 0.00 | 2478.34 |
| Alonso, Alfredo, T,23323 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Gao, Krystal,25821 | 1879.07 | 0.00 | 699.10 | 0.00 | 1179.97 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Jai, Jaime, M,24894 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gill, Monique, L,17727 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Beck, Barbara,26547 | 1407.96 | 0.00 | 0.00 | 782.99 | 624.97 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| She, Lindsay,29456 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Subram, Evelyn, S,21257 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Rana, Evelyn, D,18262 | 142.45 | 0.00 | 0.00 | 0.00 | 142.45 |
| Clark, Joshua, A,26137 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Prasad, Meagan,19611 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Tang, Bridget,17730 | 4752.23 | 0.00 | 3578.27 | 0.00 | 1173.96 |
| Henderson, Dalton,24895 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Melody, E,28212 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Sara, Phillip, R,25116 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Prasad, Carmen, L,18928 | 6095.08 | 0.00 | 3578.27 | 0.00 | 2516.81 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Stone, Keith,17331 | 40.96 | 0.00 | 0.00 | 0.00 | 40.96 |
| Cai, Autumn, O,26163 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Black, Russell,18897 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Ma, Rafael, T,13022 | 2644.02 | 0.00 | 0.00 | 2049.10 | 594.92 |
| Gao, Gilbert,24165 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Garcia, Harold, K,14087 | 341.97 | 0.00 | 0.00 | 0.00 | 341.97 |
| Andersen, Colin,25053 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Zhao, Laura, T,24589 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Huang, Alan, A,12671 | 6802.13 | 0.00 | 0.00 | 2049.10 | 4753.03 |
| She, Nichole, M,11909 | 8105.31 | 0.00 | 3374.99 | 0.00 | 4730.32 |
| Zhu, Jamie, J,13140 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Shan, Jenny, W,16706 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Shan, Jaime,22020 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
Generated 2025-12-23 05:19:08.923 UTC