[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 89 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alonso, Naomi,15830 | 2680.38 | 0.00 | 0.00 | 2071.42 | 608.96 |
| Deng, Colleen, S,27728 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Chandra, Veronica,14681 | 5178.40 | 0.00 | 0.00 | 2049.10 | 3129.30 |
| Jai, Jodi, M,27971 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Tang, Sharon, M,15823 | 67.96 | 0.00 | 0.00 | 0.00 | 67.96 |
| Munoz, Meredith,13957 | 5645.24 | 0.00 | 0.00 | 2071.42 | 3573.82 |
| Ramos, Joy,13129 | 6823.15 | 0.00 | 0.00 | 2049.10 | 4774.05 |
| Watson, Nathaniel, H,25826 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Hu, Ramon,23439 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Madan, Evelyn, D,22582 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Gill, Mathew, M,27486 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Serrano, Deanna, W,15144 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Malhotra, Arthur, E,25267 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Raji, Maurice, C,20619 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Deng, Johnny,21409 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Xu, Brad,26157 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chandra, Rebekah,28486 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Sharma, Misty,25708 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Moreno, Tabitha,19959 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Lin, Karen,24243 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Zhu, Wesley, L,19624 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Ortega, Alfredo, W,25958 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
Generated 2025-12-23 12:21:21.926 UTC