[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 21 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Suarez, Hector, L,15034 | 103.45 | 0.00 | 0.00 | 0.00 | 103.45 |
| Reed, Riley, A,20157 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 0.00 | 143.45 |
| Ramos, Adrienne, L,28216 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Coleman, Jocelyn,20606 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Xie, Alicia,26427 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Alvarez, Mathew, L,17494 | 111.96 | 0.00 | 0.00 | 0.00 | 111.96 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Rana, Meredith,25032 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Xie, Dawn,21391 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Xu, Tracy, L,17916 | 4787.74 | 0.00 | 3578.27 | 0.00 | 1209.47 |
| Collins, James, E,26742 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Guo, Jon,22927 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
| Smith, Tina, K,19793 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Shan, Keith, T,20996 | 4149.99 | 0.00 | 3578.27 | 0.00 | 571.72 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 0.00 | 2049.10 | 3599.82 |
| Gutierrez, Diana,19676 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
Generated 2025-12-22 03:09:41.248 UTC