[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 22 < SKIP 3500 > < TAKE 500 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mehta, Preston, G,18692 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Raji, Kathryn, C,21995 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Goel, Gilbert,15596 | 4460.04 | 0.00 | 0.00 | 2049.10 | 2410.94 |
| Ross, Julian,11363 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Vazquez, Marie,21899 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Ye, Ramon,11357 | 4943.80 | 0.00 | 3374.99 | 0.00 | 1568.81 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Lee, Richard, I,23996 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 2049.10 | 1760.47 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Gao, Todd, M,11061 | 8129.02 | 0.00 | 3374.99 | 2369.96 | 2384.07 |
Generated 2025-12-22 02:30:12.830 UTC