[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 3 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gomez, Marc, J,21880 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Ramos, Meredith, A,23307 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Prasad, Francisco,16628 | 187.58 | 0.00 | 0.00 | 0.00 | 187.58 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| Gonzalez, Jan, A,15262 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Raman, Levi,29114 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Lin, Alan,22973 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gutierrez, Jaime, A,25227 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Kumar, Ricardo, K,14133 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Suri, Evelyn, A,21223 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Guo, Cedric, R,27487 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Smith, Kristi, M,21962 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Suarez, Meghan, L,22177 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
Generated 2025-12-22 01:17:39.486 UTC