[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Yuan, Julie,22959 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Gill, Leslie,14670 | 2919.89 | 0.00 | 0.00 | 2071.42 | 848.47 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Rodriguez, Ruth, R,26179 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Munoz, Anne,15798 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Moyer, Meghan,21220 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Raji, Karl,29103 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Ye, Krystal, M,26923 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Chander, Roger,25214 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Allen, Devin,15806 | 102.85 | 0.00 | 0.00 | 0.00 | 102.85 |
| Pal, Roger, D,27705 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhao, Glenn, C,14221 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
Generated 2025-12-23 07:15:13.249 UTC