[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 40 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rodriguez, Donald, L,28351 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Shen, Calvin, W,26145 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Wu, Marshall, J,15590 | 4440.05 | 0.00 | 0.00 | 2049.10 | 2390.95 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 0.00 | 226.95 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2049.10 | 1581.83 |
| Pal, Mitchell, R,16742 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Diaz, Frank, F,29086 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Moore, Nathan, N,28323 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Zhu, Colin,19973 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 0.00 | 2071.42 | 4734.05 |
| Romero, Dwayne,28314 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Nara, Priscilla,18907 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Gonzalez, Edgar, A,15648 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Ortega, Danny, K,19794 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Schmidt, Shane,17922 | 4821.72 | 0.00 | 3578.27 | 0.00 | 1243.45 |
| Zhu, Tiffany,26437 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| Garcia, George,20160 | 4237.22 | 0.00 | 3578.27 | 0.00 | 658.95 |
| Vazquez, Francis, E,17281 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Raji, Maurice, C,20619 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Guo, Trisha,18253 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Jenkins, Noah, A,24379 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Suarez, Melody, H,14276 | 5259.36 | 0.00 | 0.00 | 2049.10 | 3210.26 |
| Shen, Shawn,19270 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Wood, Julia, L,12356 | 6810.13 | 0.00 | 2049.10 | 0.00 | 4761.03 |
Generated 2025-12-22 02:07:25.906 UTC