[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 7 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Tang, Shawn,25832 | 1850.86 | 0.00 | 699.10 | 0.00 | 1151.76 |
| Coleman, Ethan, G,16693 | 6060.50 | 0.00 | 3578.27 | 2482.23 | 0.00 |
| Navarro, Melinda,11454 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Chen, Kristen, L,22002 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Blanco, Lee, M,16660 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Raje, Raul, L,26785 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Liu, Glenn,18899 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Gao, Jake, A,19955 | 173.45 | 0.00 | 0.00 | 0.00 | 173.45 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Henderson, Wyatt,16697 | 87.08 | 0.00 | 0.00 | 0.00 | 87.08 |
| Dominguez, Theodore, F,21987 | 4638.89 | 0.00 | 0.00 | 2181.56 | 2457.33 |
| She, Eugene, L,20998 | 2806.51 | 0.00 | 2181.56 | 0.00 | 624.95 |
| Ruiz, Marvin, R,18796 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Zhang, Edwin,15785 | 4454.35 | 0.00 | 0.00 | 2071.42 | 2382.93 |
Generated 2025-12-22 01:22:23.182 UTC