[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 52 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rodriguez, Ruben,12589 | 2665.06 | 0.00 | 0.00 | 2049.10 | 615.96 |
| Sun, Aimee, R,18319 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
| Chander, Latoya, C,26138 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Jai, Melvin, M,27722 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Butler, Katherine, F,26760 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 0.00 | 3629.79 |
| Sai, Cassandra, R,28110 | 845.31 | 0.00 | 0.00 | 0.00 | 845.31 |
| Becker, Jenny,17290 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Ortega, Julio, M,11892 | 8119.03 | 0.00 | 3399.99 | 0.00 | 4719.04 |
| Jai, Karla,18263 | 126.94 | 0.00 | 0.00 | 0.00 | 126.94 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Serrano, Julio,20992 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Rana, Evelyn, D,18262 | 142.45 | 0.00 | 0.00 | 0.00 | 142.45 |
Generated 2025-12-21 02:34:56.432 UTC