[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 17 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Van, Brenda, J,24890 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sharma, Clayton, D,12240 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Raje, Rafael, M,13000 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Green, Fernando,17258 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Zhu, Louis,14858 | 196.97 | 0.00 | 0.00 | 0.00 | 196.97 |
| Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Serrano, Tyrone,11360 | 5025.80 | 0.00 | 3399.99 | 0.00 | 1625.81 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| Shan, Franklin, C,27718 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Gill, Mathew, M,27486 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Torres, Gina,17904 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Ye, Franklin, L,13952 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Gao, Todd, M,11061 | 8129.02 | 0.00 | 3374.99 | 2369.96 | 2384.07 |
| Sharma, Alvin, M,19586 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Xu, Cristina,25017 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 2294.99 | 2419.06 |
| Jai, Melvin, M,27722 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Lin, Dawn, N,15805 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| She, Susan,19956 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Garcia, Monica, D,20267 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
Generated 2025-12-23 08:46:10.690 UTC