[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 66 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martinez, Tyler, T,28201 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Sai, Preston, D,17046 | 4467.74 | 0.00 | 3578.27 | 0.00 | 889.47 |
| Raman, Jay, M,13618 | 6763.15 | 0.00 | 0.00 | 2049.10 | 4714.05 |
| Lu, Glenn,12692 | 156.26 | 0.00 | 0.00 | 0.00 | 156.26 |
| Suarez, Meghan, L,22177 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Martinez, Holly, B,19628 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Rodriguez, Toni, J,25251 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Malhotra, Heidi, A,26426 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Vazquez, Marvin, K,21953 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Ma, Louis,21879 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Luo, Raul, Q,20154 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Rodriguez, Sergio, D,15239 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Zhu, Ernest,20159 | 4167.23 | 0.00 | 3578.27 | 0.00 | 588.96 |
| Evans, Jackson,14321 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Raman, Edgar, A,27596 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Rubio, Randall, M,17286 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Jimenez, Tanya, D,19970 | 6099.10 | 0.00 | 3578.27 | 0.00 | 2520.83 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| She, Eugene, L,20998 | 2806.51 | 0.00 | 0.00 | 2181.56 | 624.95 |
| Lu, Suzanne, K,16712 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Arthur, Kristi, W,16675 | 4385.03 | 0.00 | 3578.27 | 0.00 | 806.76 |
| Ramos, Joy,13129 | 6823.15 | 0.00 | 0.00 | 2049.10 | 4774.05 |
| Rai, Rafael, H,18715 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
Generated 2026-01-04 05:48:48.983 UTC