[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 65 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Vazquez, Krista,26164 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liang, Colin,13639 | 188.96 | 0.00 | 0.00 | 0.00 | 188.96 |
| Suri, Cassandra, B,18717 | 87.21 | 0.00 | 0.00 | 0.00 | 87.21 |
| Gao, Krystal,25821 | 1879.07 | 0.00 | 699.10 | 0.00 | 1179.97 |
| Munoz, Audrey, V,12003 | 8256.50 | 0.00 | 3374.99 | 0.00 | 4881.51 |
| Ruiz, Alfredo,21975 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Serrano, Tyrone,11360 | 5025.80 | 0.00 | 3399.99 | 0.00 | 1625.81 |
| Adams, Devin,21871 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Serrano, Anne,24244 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Rodriguez, Heidi, L,25120 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Allen, Luis, C,26019 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Lopez, Heidi,11052 | 8131.32 | 0.00 | 3374.99 | 2337.27 | 2419.06 |
| Nara, Edwin, R,11097 | 8099.03 | 0.00 | 3374.99 | 0.00 | 4724.04 |
| Zhu, Alisha, G,18239 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Hu, Kristen, C,19788 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Nara, Priscilla,18907 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Walker, Seth, E,27689 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zhao, Ernest, C,18700 | 5328.23 | 0.00 | 3578.27 | 1749.96 | 0.00 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Gao, Jake, A,19955 | 173.45 | 0.00 | 0.00 | 0.00 | 173.45 |
Generated 2025-12-22 00:47:32.888 UTC